Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: sqlplus-command "host" in pl/sql?

Re: sqlplus-command "host" in pl/sql?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 9 Feb 2001 18:14:44 +0100
Message-ID: <t88ao8l8lhlv7d@beta-news.demon.nl>

You need to use the external procedure facility, or the dbms_pipe package or the PLEX utility on the website of Thomas Kyte

Hth,

Sybrand Bakker, Oracle DBA

"Jan Haase" <jh_at_informationsdesign.de> wrote in message news:3A84105E.28476835_at_informationsdesign.de...
> Hi.
>
> I want to write a pl/sql-script to copy some files - specified by some
 select-statements. The database runs on hp-ux.
>
> Using sqlplus I could just type "host cp source_file target_file", but
 this doesn't work with pl/sql.
> I need a mechanism to give a string containing the command to the
 operating system and wait for the return value.
>
> Any hints?
>
> Thanks in advance,
> Jan
>
>
Received on Fri Feb 09 2001 - 11:14:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US