Stopping Oracle stored procedure from Java code

[nkunkov]

Hello,
I do hope somebody has already solved my problem.
I have an application that spawns 4 different threads. Each thread
will perform it's own task which is calling a stored procedure. Each
stored procedure could possibly run a very long time. The user should
be able to stop any of the tasks he started. Stopping a task means
stopping a stored procedure and doing the clean up of the affected
tables.
My only idea on how to stop a stored proc is to close the database
connection that the thread is using to call a stored procedure. I'm
not sure it's such a good idea though... What are my options?
I would appreciate any help on this matter.
Thanks in advance.
NK

 

[Jope]

I thing you should ask this kind of questions
from Oracle's forums. Address is below, at least those people
should know the answer.

Cheers,

http://forums.oracle.com/forums/categoryHome.jspa?categoryID=84