Home » SQL & PL/SQL » SQL & PL/SQL » Procedure getting hanged (Oracle 9i)
Procedure getting hanged [message #340743] Thu, 14 August 2008 02:08 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

I have one procedure which is getting hanged if I drop it,recompile it and also while compiling it it is getting hanged.I dont know what to do with it.

Coul you please advice me what to do to drop the procedurer

Regards
Re: Procedure getting hanged [message #340744 is a reply to message #340743] Thu, 14 August 2008 02:13 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Kill the session ./fa/2866/0/

both at OS and DB Level

Regards,
rajat

[Updated on: Thu, 14 August 2008 02:15]

Report message to a moderator

Re: Procedure getting hanged [message #340752 is a reply to message #340743] Thu, 14 August 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check if there is access (v$access) or lock (v$lock, dba_lock, v$locked_object, dba_ddl_lock...).
Activate a trace on the session to see what it does.

Regards
Michel
Re: Procedure getting hanged [message #340770 is a reply to message #340752] Thu, 14 August 2008 04:05 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

I can see the lock of the procedure in the dba_ddl_locks data dictionary view.How I should overcome this issue.?The lock type is Table/Procedure/Type.The lock name is the procedure name.The mode requested is none and mode held is null.I wanted to drop this procedure.Any help to overcome this issue.

Regards

[Updated on: Thu, 14 August 2008 04:09]

Report message to a moderator

Re: Procedure getting hanged [message #340786 is a reply to message #340743] Thu, 14 August 2008 05:05 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

Thank you very much sir.I tried to killed the session and now I can see the procedure have been dropped from my user.

Regards

[Updated on: Thu, 14 August 2008 05:05]

Report message to a moderator

Re: Procedure getting hanged [message #340788 is a reply to message #340786] Thu, 14 August 2008 05:09 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
./fa/1964/0/

Can you post the code for the procedure.
Are you facing Hanging Procedure Issue first time??


Regards,
Rajat
Previous Topic: Execption handling
Next Topic: nested decode help
Goto Forum:
  


Current Time: Fri Dec 09 04:06:08 CST 2016

Total time taken to generate the page: 0.13819 seconds