Alex Rivera | Logout

Compiling Stored Procedure hangs Oracle SQL Developer

Asked 2011-07-23T11:33:29.563
13

I am facing an unusual problem in Oracle SQL Developer. When I try to compile a store procedure it hangs up the Oracle SQL DEveloper Screen and I can't do any activity, except to kill the SQL developer instance and start again.

But the same issue. Anybody faced such problem? I am new to oracle.

Here some additions to the problem I waited for 5 to 10 mins and got this error

ORA-04021 timeout occurred while waiting to lock object

But I am the only person working on this instance of Oracle

stored-procedures oracle10g compilation oracle-sqldeveloper
Edit
Report

1 Answer

1

Query v$locked_object to see if any objects that are currently locked are in use by your Stored Procedure. If so, track down the query/module which has it locked & end the query.

The link given by Thomas gives the details of how to kill a session, once the sessions are killed & v$locked_object shows no records, you should be able to compile fine.

answered 2011-07-24T12:30:39.463

Your Answer