Can´t Drop Procedure

[fmsousa]

Hi there!

I cannot drop a procedure. I think there is a problem with data dictionary and this object (procedure).

Can u tell me if there is any package that drop procedures that cannot been dropped normaly?

Thanks in advance,
Fernando Sousa

 

[carp]

How are you trying to drop the procedure and what error are you getting?

 

[fmsousa]

with:

drop procedure proc_XXXX;

i don´t receive any error, but i wait more than 15 minutes and nothing... (time out)

 

[sem]

It may be locked by another session (is executed currently). Just wait or explore v$open_cursor to find a session and kill it.

Regards, Dima

http://seminihin.narod.ru