DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001
    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

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.