Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

turning off verbose output of pl/sql?

462 views
Skip to first unread message

Robert William Vesterman

unread,
Aug 1, 2000, 3:00:00 AM8/1/00
to
Can I turn off all of the output like "Table created", "1 Row
Inserted", "PL/SQL procedure successfully completed", and so on?

Can I do so while retaining error output (e.g. "Error at line 1:
ORA-00942: table or view does not exist")?

And retaining output that I explicitly put into my scripts via
dbms_output?

Ideally, I would like to see the verbose output in response to
something that I directly type in to pl/sql, but not in response to a
part of a saved script that I'm executing. But, if that's not
possible, I'd still be mostly happy with a toggle that I would
manually turn off and on whenever I wanted or didn't want the verbose
output.

Thanks,

Bob Vesterman.

Sybrand Bakker

unread,
Aug 1, 2000, 3:00:00 AM8/1/00
to
You can turn off *sqlplus output* (mark the distinction) by issuing
set feedback off
This will not affect error messages and serveroutput.

Hth,

Sybrand Bakker, Oracle DBA

"Robert William Vesterman" <bob....@vesterman.com> wrote in message
news:3986d74b...@News.CIS.DFN.DE...

0 new messages