Very Computer

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.

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

Quote:> 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.