Calling An External Executables in a PLSQL Block

[Sekhar]

Hi,

Is it Possible to Call an External Executables in a PLSQL Block.

I know to call the Executables from a SQL PROMPT Using

HOST Command.

[TimHall]

You can do this using EXTPROC. This process allows you to run external procedures from PL/SQL.

On NT/2000 it is simplified even further by the COM cartridge. You'll need to write a DLL in VB or C to shell out to the OS. Once the DLL is registered you can access it using the COM cartridge. See:

http://www.oracle-base.com/Articles/...tomation8i.asp

The same thing is possible on UNIX using EXPROC directly with shared libraries.

Depending on what you need to do it may be better to write the process in Java and call this from your PL/SQL.

PS. Try to avoid doing any GUI stuff as this will cause EXTPROC to freak.

[Edited by TimHall on 02-27-2002 at 04:05 AM]