Cancel or stop execution of a procedure ??
118857Apr 2 2002 — edited Sep 20 2004Hello,
Our team is working on a project which involves scanning the tables in the schema of the user logged into the application.
Now the tables in this case are quite huge and the scanning takes time to complete.
There is a button in the form which calls the procedure which scans the schema.
I want to know whether there is a way by which the user can cancel or halt the execution of the procedure once it has been invoked i.e can we give a "CANCEL" button which stop the procedures execution once it has started.
I guess this would be possible if forms were multi threaded !!!
I dont know !! Is there a way ????
Thanks for your time
Nipun Suri