and save it on the d:\scott\my_scripts folder, then, at the SQL> prompt, you can enter
SET HEADING OFF SPOOL dept.txt SELECT * FROM scott.dept; SPOOL OFF
and SQL*Plus will execute all the code in the script, but the contents of the script will not appear in the SPOOL file.
Anjali wrote:Look at the example I posted: the SPOOL commands were in the script. You're apparantly typing them at a SQL> , which is why they're appearing in the output.
I placed all the commands in file and then executed, but still i am facing the same issue.
Below is what i am trying to do:
set heading off;
set feedback off;
spool 'D:\new_file.ctl' create;
In the commands.sql, i am calling a procedure. The spooled file which is getting created is as:Do you want to suppress messages like "Execution started." and "10 records executed", too? They don't look familiar to me. Are they something that your procedure is printing, using dbms_output? If so, try
10 records executed
20 records executed
30 records executed
40 records executed
I don't want the @D:\commands.sql; and spool off; commands to be writen in my output file. What should i do for it??
before running the scrpt (or in the script, but before you start SPOOLing). Remember to turn it ON again afterwards.
SET SERVEROUTPUT OFF