Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: sqlplus-command "host" in pl/sql?
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
![]() |
![]() |