execute dynamic code problem witch Parser stack overflow
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.