OraFAQ Forum: Client Tools » spool without user respons

Home » Other » Client Tools » spool without user respons

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spool without user respons [message #246805]

Fri, 22 June 2007 01:12

ddaannyy
Messages: 13
Registered: March 2007

Junior Member

Hi

my problem is, that i want not get a ask like below, if i start my sql-statement:

test: SQL> @script.sql;
Weiter: <RETURN>, Abbruch: <CTRL + C>

My script.sql looks like so:

set linesize 200;
set pagesize 10000;
set heading on;
set colsep ' ';
spool /out/script.cvs;

select ...

spool off;
exit;

If i let it running with pagesize 0 it works, but then i get not the first line. Mad