Create package from procedure
127414Nov 16 2005 — edited Nov 23 2005Hello everybody. I have this problem: in small application created in PL/SQL i need to create new user and create common app package in the new user's schema. Something like this:
begin
execute immediate 'create user new_user .....';
...
execute immediate ' CREATE PACKAGE new_user.SRC .......';
execute immediate ' CREATE PACKAGE BODY new_user.SRC .......';
end;
The problem is, that the package is too large ( 72kB) and execute immediate does not work with CLOB.
Have anybody an idea how to solve it?