Hi,
I have an exe existing in NT environment and my oracle is existing in Solaris environment. Can anyone tell me if it is possible to call my exe from Oracle PL/SQL procedures? If Yes how can I do it.
Thanks
Printable View
Hi,
I have an exe existing in NT environment and my oracle is existing in Solaris environment. Can anyone tell me if it is possible to call my exe from Oracle PL/SQL procedures? If Yes how can I do it.
Thanks
Write an an agent for NT that opens a connection to Oracle and waits for an alert. Call the exe after the alert comes.
See the dbms_alert and dbms_pipe packages.
The agent might by anything able to call exe (java, C, VB, .bat & sqlplus)