Re: Executing OS command from PL/SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 19 Oct 1999 10:41:30 GMT
Message-ID: <380c4a6f.12445960@news.demon.nl>

Sorry, but this is not true.
In 7.3.3 there is the dbms_pipe facility. You could use the PLEX utility on http://osi.oracle.com/~tkyte as a wrapper in order not have to work with pipes yourself.

Hth,

Sybrand Bakker, Oracle DBA

On Tue, 19 Oct 1999 12:37:03 +0200, "Ivan Bajon" <iba_at_no_spam_at_post1.tele.dk> wrote:

>Hi Grigor
>
>Sorry, but that's a no-go. You can in Oracle8 but not in Oracle7. You can do
>it in SQL*Plus, if that's any help:
>
>[sql*plus script]
>execute mypack.myproc
>host copy ...
>exit
>
>
>
>Grigor Coric <grigor.coric_at_lijanovici.com> wrote in message
>news:7uhfaq$7oc$1_at_as102.tel.hr...
>> Hi,
>>
>> I'm trying to find a way to execute an OS command (like "copy) from PL/SQL
>> stored procedure.
>> Can somebody help me with that ?
>>
>> I'm running Oracle 7.3.3 on WinNT.
>>
>> --
>> Grigor Coric /grigor.coric_at_lijanovici.com/
>> Zagreb, Croatia
>>
>>
>
>
Received on Tue Oct 19 1999 - 05:41:30 CDT