Re: operating system calls from PL/SQL

For Oracle7 use something like PLEX
(http://www.oracle.com/database/features/plsql/plexdoc_toc.html). For Oracle8 use the built-in feature External Procedures (http://www.oracle.com/oramag/oracle/99-Jan/19or8.html for UNIX and http://technet.oracle.com/support/scr/content/471/471.htm for Windows NT).

HTH. Finn

Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote in message news:379C4B1E.BEC7D2D_at_Unforgettable.com...
> David Kaplan wrote:
>
> > Hi,
> >
> > Similar to a host command in either sqlplus or in an Oracle forms
> > environment - in order to execute an operating system call
> >
> > is their a way to execute operating system calls from within a pl/sql
> > block - like in a stored procedure?
> >
> > I appreciate any input on this
>
> The reason that there is no native ability to perform system calls from
> within PL/SQL is because it would be too much of a security hole. If you
> really need to intereact with the system then you must do it via
> DBMS_PIPE.
>
> Ken
>
Received on Mon Jul 26 1999 - 19:55:50 CEST