Re: spool question

Tony,

Is there a way to disable screen output when I run in at the SQL> prompt? I'm piping the select statement to sqlplus like this:

#!...perl

open SQL, "| sqlplus usr/pasw";
print SQL "set term off\n";
print SQL "spool myout\n";
print SQL "select * from employee\n";

It still shows the output on screen.
Thanks for a reply.

Yong Huang
Email:yong_at_shell.com

Tony Gayda wrote:

> Dennis-
>
> You need to "SET TERM OFF" in order to prevent output from going to your
> screen. This only works if you are running your SELECT statement from a
> ".sql" script and not directly entering it at the "SQL>" prompt.
>
Received on Wed Jun 10 1998 - 17:33:59 CEST