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.