Home » SQL & PL/SQL » SQL & PL/SQL » Terminating an Oracle PL/SQL procedure from Unix
Terminating an Oracle PL/SQL procedure from Unix [message #27] Fri, 04 January 2002 07:29 Go to next message
Elizabeth
Messages: 6
Registered: January 2002
Junior Member
Hi,

I am encountering the following problem.

I have this script that i execute as a background process on unix. The script internally invokes a java program that calls PL/SQL procedures in oracle8.0.4.3.0. When I kill the process I am not sure if the executing stored procedures are also killed. Is there a way to check this and terminate the procedures if required (using a unix script).

Thanks in advance,
Elizabeth

----------------------------------------------------------------------
Re: Terminating an Oracle PL/SQL procedure from Unix [message #29 is a reply to message #27] Fri, 04 January 2002 10:39 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
if you kill unix process it automatically kills oracle execution. query v$session view if you want to check current sessions running.

----------------------------------------------------------------------
Previous Topic: report output to an excel file
Next Topic: Re: Encript Data
Goto Forum:
  


Current Time: Fri Aug 14 10:01:07 CDT 2020