Re: multi threading
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 26 Aug 1999 11:52:56 GMT
Message-ID: <37c72a6a.3030667_at_newshost.us.oracle.com>
Date: Thu, 26 Aug 1999 11:52:56 GMT
Message-ID: <37c72a6a.3030667_at_newshost.us.oracle.com>
A copy of this was sent to Shibu Stephenson <shibu.s_at_pacific.net.sg> (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 http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle CorporationReceived on Thu Aug 26 1999 - 13:52:56 CEST