Re: PL/SQL

From: Mervyn at ifwdc.com <merv_at_ifwdc.com>
Date: 2000/05/11
Message-ID: <8ff5g8$1lct$1@brimstone.medianet.ie>#1/1

James,

You an use a PIPE concept with Oracle. I've used this with Unix in the past with good success. You can also generate files on the server platform using FILE_UTL (or similar :-) )

You can use this to generate unix scripts or .bat files. These can then be picked up and run by a cron type job on unix, or similar on NT I assume (not NT familiar). This method will work, but you cannot get back a success or fail. You need to do messy stuff by writing status data into files, and then read them using the file_utl packages.

I know this is a bit sketchy. it should give some pointers though.

Merv.
> Is there any way (in PL/SQL) to access the command line for Unix or NT?
> I am looking for any information on how to do this, either through
> staight PL/SQL or even through an external language if need be.
>
> I would appreciate any help.
>
> James
>
Received on Thu May 11 2000 - 00:00:00 CDT