Re: operating system calls from PL/SQL
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 26 Jul 1999 07:48:46 -0400
Message-ID: <379C4B1E.BEC7D2D_at_Unforgettable.com>
Date: Mon, 26 Jul 1999 07:48:46 -0400
Message-ID: <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 - 13:48:46 CEST