Re: Launching a VMS program / command procedure from within SQL or PL/SQL

This can be accomplished using a combination of the DBMS_PIPE package and a 3GL program that communicates via the PIPE. The 3GL program is started as a detached process and listens for a message on the PIPE. Your trigger would send a message on the PIPE thus waking the 3GL program to take whatever action is necessary. I use this type of setup to send mail messages from Oracle procedures and also to "load" RMS files on VMS into Oracle tables. Users pass owner, table name, and file name and the file is read and inserted into the table.

For a better explanation see the Oracle7 Server Application Developer's Guide.

-- 
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)

siim <siim_at_specht.demon.co.uk> wrote in article
<877377515.401.0.nnrp-02.c2de61d4_at_news.demon.co.uk>...


> hi all,

> 

> I was wondering if it is possible to launch a VMS program or command

 procedure 


> from a SQL or PL/SQL script. The idea is to use Oracle to synchronize two

 


> programs. One program would write a filename into a column in a table.

 This 


> column would have a trigger associated with it, which would have to kick

 off a 


> VMS program, which would do something with that file. 

> 

> Can anybody help me with this ? Any help would be greatly appreciated.

> 

> I know I could poll the database to detect a change in that table, but I

 don't 


> consider that as a clean solution.

> 

> Thanks,

> Ivan Mermans

> 

>