Re: Oracle Job Queues

Hi Jay,

have you tried using DBMS_PIPE to pipe a run request to a Pro COBOL or Pro C executable which in turn executes whichever 3GL is to be run.

DBMS_JOB could then schedule a PLSQL procedure which could execute the DBMS_PIPE call.

The whole process would be parameterised so that it would become a generic execution layer.  

A potential alternative would be DBMS_ALERT executed from within a Pro C executable. The 3GL waits on the alert which is raised by a PLSQL procedure executed via DBMS_JOB and then executes the required 3GL. Lots of ways to parameterise it.

regards

Rod Corderey

Lane Associates
RodCorderey_at_Lane-Associates.com
http://www.Lane-Associates.com

Jay McDougal wrote:
>
> You can schedule routine jobs using Oracle job queues. But, I
> have only been able to start PL/SQL stored programs this way.
>
> Our company has tons of old PRO COBAL and PRO C
> programs that we could be running in Oracle job queues if
> I only knew how.
>
> Has anyone ever used Oracle job queues for running these
> kind of programs??
Received on Tue Nov 16 1999 - 08:37:16 CET