Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: executing pl/sql in parallel
Try DBMS_JOB instead.
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ <kevin_at_english.net> wrote in message news:8fpdd2$m9k$1_at_nnrp1.deja.com...Received on Mon May 15 2000 - 00:00:00 CDT
> 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.