Re: Calling executables from within PL/SQL

You can do this, the way to accomplish this is to use DBMS_PIPE package. Basically, you send a message to the OS to run the executable. You have to be careful with this package as that my company has found that it can not handle a large number exe runs through the pipe even though it is Asynchronous calls in the package.

HTH
Tx
Eric Peterson, DBA
Maurices Inc.
eric_NOpeterson_at_maurices.inrg.SPAMMERScom

The views I have expressed are solely my own and not that of my company's. To email me, remove the NO and the SPAMMERS in the address above.

In article <38aa826f.0_at_d2o61.telia.com>,   "Ola Nissen" <ola.nissen_at_ifsab.se> wrote:
> Hello all,
>
> does anyone know if there is a possibility to start a program (an
 executable
> on
> the server running the database) from within PL/SQL? I would like to
 start
> an executable, sending a parameter list to it, from within a PL/SQL
> procedure?
>
> Also, is there any possibility to use COM objects from within PL/SQL?
>
> Thankful for all advice and response.
>
> Ola Nissen
> Systems Developer
> mailto:ola.nissen_at_ifsab.se
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 16 2000 - 00:00:00 CET