Re: is it possible to execute a unix command from an oracle procedure?

I've not used 8 for this - though I recall having looked at some stuff on executing unix commands using it, and didn't think it very simple.

There is a semi-recommended method for Oracle 7 - though it's not pretty. (Can't see why it wouldn't work for 8 as well.) It involves the use of the DBMS_PIPE package and having a C daemon that checks the output of a pipe.
If you check the Server Application Developer's Guide section on DBMS_PIPE then I think you'll find plenty of (almost complete?) code in there.

Mike W-M
mike_at_ward-murphy.demon.co.uk

On Thu, 1 Jun 2000 10:21:40 +1000, "Tom Zamani" <tomz_at_redflex.com.au> wrote:

>oracle 7.X NO, Oracle 8.X Yes.
>in Oracle 8.1.6 there is a package which is used for external procedure
>call.
>Tom
>NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
>news:39358413.95880248_at_news.earthlink.net...
>> is it possible to execute a unix command from an oracle procedure?
>> and save it's output in a variable?
>>
>> Thanx
>> ---------------
>> In case I forgot to mention:
>> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
>> ---------------
>> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
>> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
>
Received on Thu Jun 01 2000 - 00:00:00 CDT