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_at_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 CEST

Original text of this message