SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Plus suppress sql prompt

bentonDec 7 2007 — edited Dec 9 2007

Hi,

When using SQL*Plus and spooling to a file is it possible to suppress the following sort of messages form being written to the output (spool) file.

SQL> @C:\script_drop_schema\DROP_SCHEMA.SQL

... Script results

PL/SQL procedure successfully completed.

SQL> SPOOL OFF

The reason I ask is I want to use the results immediately and don't want to see errors being thrown up by the above text. I only want to see valid(?) error.

Thank You
Ben

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2008

Added on Dec 7 2007

6 comments

5,103 views