Link to home
Start Free TrialLog in
Avatar of brgdotnet
brgdotnetFlag for United States of America

asked on

Not able to drop or recreate an Oracle stored procedure

I am using Oracle Sql developer to write and maintain stored procedures, tables etc. I have one stored procedure that I am not able to drop or re-create. If I try to drop or recreate the store procedure, I just get the little gauge above that indicates that something is running. Yet nothing ever happens. On one occasion, about a half hour later I received an error message. The error message is shown below. Also I tried changing the stored procedure so that it  is very small in size. Like just 30 lines of Sql. Yet if I try and drop and recreate with the new small stored procedure, it still seems to lock up, processing forever. I did notice that the stored procedure has the little red X icon next to it, indicating that it has compiler errors. Anyway, how can I just get rid of or delete this stored procedure?


Error message :  An error was encountered performing the requested operation:
ORA-04021: timeout occurred while waiting to lock object. 04021.00000 - "timeout occurred while waiting to lock object %s%s%s
*Cause:  While waiting to lock a library object, a timeout is occurred. *Action: Retry the operation later. Vendor code 4021.





 I have one stored procedure which has the little red
error icon by it indicating that something is syntactically wrong in the stored procedure.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial