Cancel stored procedure
Posted on 2002-04-22
I need to call an oracle stored procedure from a vb dll. The stored procedure basically has an insert statement for multiple rows.
How can I cancel the stored procedure if it takes more time say (30min). The process should also be killed in the oracle side.
When i used the commandtimeout of ADO command object, it didnt work. Moreover if I kill the VB session in the client side, the stored procedure still runs in the oracle side. Any suggestions?