This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off select * from dual; set termout on set head on set echo on set feedback on 4- spool off Spool file has expected output, which is result of sql statement ONLY!
Now when i place following in a shell script and run it ____________________________ #!/bin/ksh $ORACLE_HOME/bin/sqlplus liserv/liserv@webny << EOF set feedback off set head off set echo off set termout off spool output.txt select * from dual; spool off set feedback on set head on set echo on set termout on exit; _______________________________ Now question is that in later case where i use shell script along with out put of query , WHY DO I SEE THE ACTUAL SQL STATEMENT IN SPOOL FILE ALSO? Even though i have feedback, echo and termout off . Any way around. I want ONLY output of query in spool file when sql file is run using a SHELL SCRIPT!. Thanks. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).