Re: PL/SQL how to execute os commands
From: Steve Mitchell <steve_at_mitchells.demon.co.uk>
Date: 1997/05/27
Message-ID: <338AD95E.4E0B_at_mitchells.demon.co.uk>#1/1
Date: 1997/05/27
Message-ID: <338AD95E.4E0B_at_mitchells.demon.co.uk>#1/1
Jeroen Bontje wrote:
>
> Johnny Verhoeven wrote:
> >
> > HI,
> >
> > How can I run a unix command from within a PL/SQL stored procedure ?
> >
> > Thanks,
> >
> > Johnny
>
> By using Oracles Foreign Function Interface. Look in the
> orawin/form45/foreign dir for an example.
>
> Good luck
>
> Jeroen Bontje
The Foreign Function Interface is available only to client side PL/SQL, i.e. Forms 4.5
To execute OS commands from stored procedures you need to use the DBMS_PIPE package.
Review the file $ORACLE_HOME/rdbms/admin/dbmspipe.sql for information on how to use this package. Received on Tue May 27 1997 - 00:00:00 CEST