Ignore Sql prompt and command entered while spooling [message #528397] |
Mon, 24 October 2011 12:01 |
prax_14
Messages: 64 Registered: July 2008
|
Member |
|
|
Dear friends,
Is it possible to ignore the sql command prompt and the command entered while spooling. I tried the to set echo off,term off and some more options but it did not work.
Example:
SQL> spool c:\test.log
SQL> Prompt "This is a test"
"This is a test"
SQL> spool off;
The spool file has the following
SQL> Prompt "This is a test"
"This is a test"
SQL> spool off;
Is it possible to set some options so that the spool file only contains output.
Thanks in advance for you help.
|
|
|
|
|
|