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!

suppress output from sql command

user8869798Nov 1 2010 — edited Nov 1 2010

hi,
is there a way that I can suppress the output from a sql command in a pl/sql script? I only want to dispaly the output from dbms_output in my spooled file. I've tried set termout off/on and echo on/off but I still get messages like : Trigger altered etc. which I will like to suppress.

thank you.

This post has been answered by Saubhik on Nov 1 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2010

Added on Nov 1 2010

4 comments

1,794 views