Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

execute dynamic code problem witch Parser stack overflow

user11078372Nov 8 2010 — edited Nov 8 2010
Hi everyone:)

Tooday I have problem with Parser stack overflow error.
I wanted to 'execute immediate' statement that would create for me Package. I can not use varchar2 as parameter because there is over 100k bytes of code.

So I have created collection like below and put in pl/sql code:

TYPE TB IS TABLE OF varchar2(4000) INDEX BY PLS_INTEGER;

TAB_B TB;

EXECUTE IMMEDIATE case when LN_COUNTER>=1 then TAB_P(1)|| case when LN_COUNTER>=2 then TAB_P(2)||.... up to 120 times...

and the problem is that close to 60 iteration I'm getting error: Parser stack overflow error.
So my idea is not correct.
Does anyone have other idea how to EXECUTE IMMEDIATE statement that have over 100K bytes and must be in parameter.
PS
I don't/cant use clobe.

Thanks for help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2010
Added on Nov 8 2010
3 comments
927 views