Re: executing pl/sql in parallel

From: Michael Moore <hicamel_at_home.com>
Date: 2000/05/16
Message-ID: <3920CEEC.61044A8_at_home.com>#1/1


Or if clean_data was a java servlet you could start multiple threads, each invoking and independent procedure.

kevin_at_english.net wrote:
>
> Hello,
> I was wondering if there is a way to execute 2 pl/sql programs in
> parallel on Oracle 8i. Basically, I have one stored procedure called
> clean_data which calls many other procedures that are all pretty much
> independent of each other. I want clean_data to call each procedure and
> not have to wait it to finish before launching the next one and thus
> execute all the procedures in parallel. . . .
> Does anyone know how to accomplish this? I thought maybe DBMS_PIPE
> would help but i can't seem to see how. Any help would be much
> appreciated. Thanks
>
> Kevin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue May 16 2000 - 00:00:00 CEST

Original text of this message