Re: PLSQL question

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 12 Oct 1998 00:24:49 GMT
Message-ID: <01bdf56e$06785900$430c400a@viao1>

Chuck,

As you are calling the procedures from within the same session, they can only work sequentially. A possible workaround is to run each of the desired procedures in seperate sessions and use pipes to send data to and receive data back from each procedure i.e. the procedures are constantly running in these other sessions and waiting to perform work when it comes down the pipe.

Andy

Hooperce <hooperce_at_aol.com> wrote in article <19981011162026.17811.00015820_at_ng91.aol.com>...
>
> From within a stored procedure, I want to fire off a few other stored
> procedures, one after the other, WITHOUT having to wait for each to
finish
> before the next takes off. Each is now waiting for the prior one to
fiinish
> before starting - how can I get around this??? Thanks, in advance, to
> all....
>
> Chuck Hooper
> Pro Relational Systems
> Charles_Hooper_at_ProRelSys.Com
>
Received on Sun Oct 11 1998 - 19:24:49 CDT