Re: pl/sql
Date: 1995/07/07
Message-ID: <3tjlpb$ept_at_server.st.usm.edu>#1/1
Michael Sundermann (michael_at_klst.com) wrote:
: i want to call a c-programm from a pl/sql program in Oracle 7.0.
: is this possible ?
Using Oracle Forms yes. Use the host command. Using a stored PL/SQL block (package, function, procedure, trigger) no.
I've spoken with several people at Oracle about this. There are no plans to _ever_ implement a host command from a stored procedure to my knowledge; this is due, I was told, to the nature of client server processing.
My information on the last bit may not be 100% accurate.
The other option is to have a pro*c program looping continuously and checking for a pipe or signal from the database (the dbms_pipe and dbms_alert packages). When the signal is received, the pro*c program interprets it and runs the apprpriate executable.
Hope this is some help
Jonathan Received on Fri Jul 07 1995 - 00:00:00 CEST