Re: Using DBMS_JOB and DBMS_PIPE to mimic multithreaded PL/SQL application

Hi Paul,

Quite an interesting idea. I did something similar a few years ago to mimic a VMS program on Solaris when we migrated a legacy cognos application from vms/rdb to solaris/oracle and a newer version of cognos powerhouse. Instead i used a combination of triggers and pipes rather than dbms_job. The way we achieved concurrency was to launch child pl/sql processes from a shell script daemon. The daemon updated itself from messages passed from the children. The messages were sent from triggers that fired when the job status queue (table) was updated. I don't have a copy of the code though.

[Quoted] BTW, why are you trying to do this?

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.