Home » SQL & PL/SQL » SQL & PL/SQL » stoping of a procedure
stoping of a procedure [message #20591] Thu, 06 June 2002 02:34 Go to next message
bharath
Messages: 30
Registered: November 2000
Member
i want to stop a procedure which is going on infinite loop

Report message to a moderator

Re: stoping of a procedure [message #20595 is a reply to message #20591] Thu, 06 June 2002 03:28 Go to previous message
shyampaliyath
Messages: 22
Registered: May 2002
Junior Member
hai bharath,
U have to kill the session thru the enterprises manager
or go to the system/manager and type
alter system kill session '<sessionid>,<Serial#>'

u can get the sessionid,serial# from v$session

Report message to a moderator

Previous Topic: Help - Complex Query
Next Topic: Verifying if the data(one row) fulfilling a select criteria exists in the table or not
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 17:26:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.