This content has been marked as final. Show 3 replies
Did you check for locking issues?
It is possible that some user might be using the procedure that you are trying to compile.
How long did you wait before killing sqlplus session? What is your Oracle version?
yes, I did check for locks from pl/sql developer only. No Locks.
I waited for 10 minutes for a 6 kb .plb file to get compiled. But had to close the session after that.
I am using oracle 10g, pl/sql developer 126.96.36.1997
sql*plus Release 10.2.0.2.0
The default lock timeout for Oracle 10g is around 15 minutes before it throws ORA-00054 error.
Can you wait a bit longer (15 minutes) to check if it is the same issue?