Re: multi threading

From: Thomas Kyte <>
Date: Thu, 26 Aug 1999 11:52:56 GMT
Message-ID: <>

A copy of this was sent to Shibu Stephenson <> (if that email address didn't require changing) On Thu, 26 Aug 1999 16:05:42 +0800, you wrote:

>How can we do Multi threading in PL/SQL?

you can't. plsql doesn't support threading.

you can 'spawn' disconnected jobs (sort of like having a shell script run something in the background on unix) using dbms_job but it doesn't emulate threading at all.

See for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte         
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Thu Aug 26 1999 - 13:52:56 CEST

Original text of this message