Re: SQL*Plus spool file and Unix command

Of course, the host command starts a new shell, and you need to use ordinary I/O redirection to accopmplish that.
You could also try to use whenever oserror, but I don't know for sure whether that address host commands too.

Hth,

--
Sybrand Bakker, Oracle DBA
Robert Chung <robertch_at_mindspring.com> wrote in message news:38506ef2.12431593_at_news.mindspring.com...
>
>
> When I run Unix command inside SQL*Plus using ! command, such as "! cp
> file1 file2" with SQL*Plus' spool on, spool file does not record any
> message from Unix command. For example, when "cp file1 file2" returns
> "No such file or directory", there would be nothing shown from "cp"
> command in SQL*Plus spool file. (Of course, spool file does show
> SQL*Plus' own SQL command results) Is there any way to capture Unix
> command output? Thank you in advance.
>
>
>
>
Received on Fri Dec 10 1999 - 14:04:46 CST