Multiple threads in PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Multiple threads in PL/SQL

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    26
    IS there a way I can run multiple threads of the same PL/SQL program in Oracle ?

    What I want to do is have a Job running in Oracle that reads from a certain table, gets some information and spawns a process. It comes again, reads some info again from the same table and spawn another process. I want to have 3-4 such threads running.

    Please suggest any alternatives also. Thanks.

  2. #2
    Join Date
    Sep 2000
    Posts
    47
    Hi,

    You can write a C/Pro*C code to perform the said task. This C/Pro*C code can start a deamon process which can give 'birth' to multiple child processes which in turn can perform the desired tasks (reading tables and performing other operations .... ).
    Do checkout whether DBMS_PIPE package can be of any help to your ....

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width