Re: Invoking a program from a stored procedure..

Iran,

I've not tried this but I have heard that the only way is to create a public pipe in
Oracle that the stored procedure writes to. On the other end of this a Pro*C/C++
program would wait on the pipe (via a PL/SQL block) for commands. Once received it could use a system call to execute the application you want.

Regards
Gary Smith

Iran Miranda Rodrigues wrote:

> Hello,
>
> I would be pleased to know if it is possible to call a program (like a
> vb application..) from an Oracle stored prcedure..
> The idea is the procedure just calling the program and then going on in
> its business..
> This procedure would be invoked through the web server..
>
> Thanks in advance...
>
> Iran M Rodrigues

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7678944
*************************