Oracle Package inside a CLOB with length > 32767 characters. How to "execute immediate" it? -

please suppose have package creation script stored inside table alpha, in column beta of type clob. clob length > 32767 characters.

using pl/sql code, "execute immediate" package creation script.

i achieve this?

thank in advance kind help.

i using oracle 10g

execute immediate didn't support clobs until 11gr2. can use dmbs_sql handle larger statements. in earlier versions build statement, 11g allows parse clob.

there example here.

creating package dynamically seems odd requirement though.

---

since you're on 10g, need use version of dbms_sql.parse lets build large statements:

the parse procedure supports following syntax large sql statements:

dbms_sql.parse (     c                  in   integer,     statement          in   varchar2s,     lb                 in   integer,     ub                 in   integer,     lfflg              in   boolean,     language_flag      in   integer);  

note: procedure concatenates elements of pl/sql table statement , parses resulting string. can use procedure parse statement longer limit single varchar2 variable splitting statement.

an example of approach here.