Hi experts. I am trying to create a stored procedure at run time using dbms_sql.parse and dbms_sql.execute. Once I have the code ready, I call something like
dbms_sql.parse("CREATE OR REPLACE myProc AS ... etc ... ");
I am getting the error "Insufficient Privileges".
The funny part is, when I create myProc manually I have no problems, and, if once created I run my program again to re-create it (replace it) dynamically, I have no problems either!!!! Any ideas?
Thanks in advance.