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: Oracle8.03/NT4.0: Multithread PL/SQL Programming

Re: Oracle8.03/NT4.0: Multithread PL/SQL Programming

From: Gary SMITH <Gary.Smith_at_cern.ch>
Date: 1998/05/15
Message-ID: <355C2B1B.7ACA9903@cern.ch>#1/1

One way to emulate separate threads of execution is to use the DBMS_JOB package and the DBMS_PIPE package together. Using the JOB package allows you to execute separate PL/SQL procedures simultaneously and the PIPE package allows you to set up communication channels between them. This works well in 7.3.X so should work ok in 8.03 (assuming backward compatibility).

Regards

Adam Tadjkarimi wrote:

> Does Oracle8.03/NT4.0 support multithreaded PL/Sql programming?,
> in otherwords, is it possible to write multithreaded PL/Sql applications?
> Thank you in advance for your input.
>
> Adam Tadjkarimi
> adamt_at_hsltd.com

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7678944
*************************
Received on Fri May 15 1998 - 00:00:00 CDT

Original text of this message

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