Re: Host commands from PL/SQL

You will need to use the DBMS_PIPE package. OS commands can be executed by a Pro*C Daemon running on the server, which listens on a named Oracle DMBS pipe for commands from your PL/SQL. It can then return the results via another pipe.

The Oracle Application Developers Guide gives details and examples.

Regards,
Mike

calderproj wrote:
>
> Hello,
>
> Does anybody know of a way of issuing host commands from withinn PL/SQL?
>
> The problem is I have a directory in which there could be any number of
> files which I need to read in turn. I know of the UTL_FILE package but
> for that you need to know the file names. What I want is to be able to do
> an ls of the directory giving all the file names.
>
> The host is Unix Solaris 2.6 using PL/SQL v2.3.
>
> Cheers
>
> MTP
Received on Thu Jun 04 1998 - 22:01:36 CDT