Re: execute more than one statement at the same time in a session ?

Okay - here's a thought - and remember that my PL/SQL is a bit weak...

create a procedure that will run in a loop (in the background) until the value for a global variable has been set to some value (X) and use this procedure to execute your dbms_alert.waitany command (on it's own thread). Then, change the global variable value to X upon exit of your application.
This may not work, but hopefully it gave you some ideas?

sonya

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 09:50:03 CST