Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8.03/NT4.0: Multithread PL/SQL Programming
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