create package

hi.

i want to dinamically create a package in a pl/sql procedure. to do this, i create a varchar2(4000) variable, write the code of the procedure in it, and then execute immediate the variable.

my problem is the limit of 4000 chars, because it could be that the package body i want to create with execute immediate is a lot larger than 4000 chars, and i can't execute immediate a clob variable (doesn't work, seems to me that execute immediate does'nt support clobs as argument).

any solutions?

(i work on oracle 9i)

-- 

regards,
Simon