not able to suppress sqlplus output on terminal

Question

I am using following script to delimited file using spool in the unix server. I ssh into it using putty and execute the shell script.

Here is shell script:

/oracle/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus -s /nolog<<-EOF

conn user/pass

SET PAGESIZE 0
SET LINESIZE 32000
SET NUMWIDTH 127
SET FEEDBACK OFF

set echo off
set heading off
set headsep off
SET MARKUP CSV ON DELIMITER | quote off
set termout off
spool mc_format.dat
select * from mytable;
spool off
EOF

but I am not able to suppress the rows printing out on the terminal, and eventually on log when I run using cron.

Is there any setting I am missing out?

user123664 · Accepted Answer · 2021-05-31 07:52:25Z

1

Right from the documentation SET TERMOUT OFF

Controls the display of output generated by commands in a script that is executed with @, @@ or START. OFF suppresses the display so that you can spool output to a file without displaying the output on screen. ON displays the output on screen. TERMOUT OFF does not affect output from commands you enter interactively or redirect to SQL*Plus from the operating system.

So instead of the here document, call the script using one of the start methods mentioned.

answered May 31, 2021 at 7:52

user123664

Sign up to request clarification or add additional context in comments.

1 Comment

curious_nustian Over a year ago

Made it to work by using START quries.sql in my shell script. Thank you

Collectives™ on Stack Overflow

not able to suppress sqlplus output on terminal

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related