Re: UNIX commands from within PL/SQL

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Mon, 6 Jul 1998 11:39:41 +0200
Message-ID: <6nq67c$9vt$1@sunrise.pg.gda.pl>

Bram Stieperaere wrote in message
<35A0993F.7B3DF712_at_N_O_S_P_A_Msodexho-pass.be>...
>Hi All,
>
>I need to have access to UNIX commands from within PL/SQL. I would like
>to
>- get a list of files in a directory and put it in another file (so
>PL/SQL can process them one by one)
>- move processed files to another directory
>
>I guess I need a PRO*C program that communicates with the PL/SQL program
>via a pipe.
>
>Does anyone know how to do this?
>

For example, use dbms_pipe package.
Very usefull to exchange information between independent Oracle sessions.

HTH,
Piotr Kolodziej Received on Mon Jul 06 1998 - 04:39:41 CDT