How to stop a stored procedure executed through SQL*Plus
445099May 23 2008 — edited May 23 2008Hi,
I have written a Unix Shell that launches a SQL script through sqlplus executable.
In the SQL file there 's only the call of a stored procedure.
So for example sqlplus login/pwd@SID @sql_script &
the command is executed in background.
But it seems that the execution of my stored procedure may take a lot of time. So i decided to kill the sqlplus unix process but in fact i see that the stored procedure is still executing (i see it in the log trace files generated). So how can I stop the execution of this procedure ? How to find the Oracle process who is in charge of running the procedure ?
Thanks a lot.