Procedure Compilation locking table

[Sharma]

I am trying to compile stored procedure, after a while it comes out with error message of time out.

*************** ERROR MESSAGE ****************
CREATE OR REPLACE PROCEDURE Insert_Update_FC(
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
INSERT_UPDATE_FC
***********************************************

The tables which are shown in lock state, With in procedure, against one table
I have UPDATE & INSERT stmt.
other table is used only for Variable Declartion with %TYPE.

the lock mode shown on both the table is 3
No other SQL stmt. is issued against these tables.

Why Oracle is trying to lock the table when compiling the procedure?

[chrisrlong]

While trying to compile INSERT_UPDATE_FC, you get an error that says it cannot lock *INSERT_UPDATE_FC*!

This has nothing to do with any table. Somebody already has a lock on your *procedure*, thereby not allowing you to get an exclusive lock on the procedure so you can replace it.

- Chris