calling an exe from oracle stored procedure

[lata]

hi,
Couid you please tell me Is it possible to call an executable file from

an oracle stored procedure.

Thanks in Advance,
lata

[Matthew Cromer]

"lata" <shobalatharaju@epatra.com> wrote:
>
>hi,
>Couid you please tell me Is it possible to call an executable file from
>
>an oracle stored procedure.
>
>Thanks in Advance,
>lata
>

It is indirectly possible. What you need is another application to open
a socket port on the target machine. When the listener app receives a specific
message, launch your desired application.

The Oracle SO can be written in Java, and use the Java socket / networking
libraries to send a message to the triggering EXE.

If you were not running the Java inside Oracle you could simply use JNI to
invoke the EXE via a createprocess call to the Win32 API, but Oracle's JVM
(Aurora) won't allow you to make JNI calls.

Matthew Cromer

[Raghu]

You can not call an EXE from a Stored procedure directly.
You have to convert your exe into a library file first and then
register your functions in the dll as external functions in Oracle.

Then you can access the functions in the library from SP's.

Refer to Oracle Programmers reference for more information.

Regards
Raghu


"lata" <shobalatharaju@epatra.com> wrote:
>
>hi,
>Couid you please tell me Is it possible to call an executable file from
>
>an oracle stored procedure.
>
>Thanks in Advance,
>lata
>