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.
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.