Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: executing pl/sql in parallel

Re: executing pl/sql in parallel

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/15
Message-ID: <bN_T4.192622$Tn4.1589420@news1.rdc2.pa.home.com>#1/1

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...

> 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 Mon May 15 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US