Is it possible to set the server output only into the spool file and not in the shell ?
set serveroutput on spool log.txt exec MY_PROCEDURE(); spool off
Inside MY_PROCEDURE I have this :
DBMS_OUTPUT.put_line('Hello World');
I would like to put Hello World only in log.txt, not in the screen shell.
Advertisement
Answer
Simplest way is to pipe the unix output to /dev/null
$ sqlplus -S user/password @test.sql > /dev/null
$ cat test.sql
set serveroutput on
set feedback off
spool log.txt
exec dbms_output.put_line('This is great!! and working');
spool off;
exit;
$ cat log.txt
This is great!! and working
$