When I try to compile any procedure I get this error
The following error has occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: You are not allowed to DROP
ORA-06512: at line 4
sounds like the creator of the procedure does not have DROP privs. Is this possibly the case?
otherwise please post the portion of the procedure that is receiving the error.
Thanks for your reply ,but this is not the case.
This error comes whenever any procedure is compiled or whenever yuu try to create a new one.
Came across from one of the posting:
Seems there is too less space for the SYSTEM tablespace.
In a runnding database environment one could use something
ADD DATAFILE SIZE 50M
Let me know if this works
Click Here to Expand Forum to Full Width