Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 01:37:16 CST