Vs: Executing external programs from a database procedure.

Hi,
try using package DBMS_PIPE. Your Pro*C program waits for a message to arrive into a pipe and then does what ever it should do. Your stored procedure writes a message to that pipe. That way Pro*C is executed near realtime but not in same transaction than the stored procedure. There is a pretty good example in $ORACLE_HOME/rdbms/admin/dbmspipe.sql

This works on 7.3.4, I guess pipes are there in version 8 too.

Timo

Ant <anorfri_at_teleline.es> kirjoitti
viestissä:KDJ%5.109856$yO2.3247911_at_telenews.teleline.es...
> Hello !!!
>
> Now I have a new (and big for me) problem. It's because I must run an exe
> file (a Pro C program) from a stored procedure. I run Oracle (8.0.4.0.0)
 on
> Compaq Unix (OSF1) V4.0. I've tried to do this whit the "host" built in,
> but it's not supported on stored program units. So, How could I run an
 exe
> file from Oracle?
>
> Thanks
>
> Ant
>
>
>
Received on Wed Dec 20 2000 - 16:02:41 CET