-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|