Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: turning off verbose output of pl/sql?
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.work_at_vesterman.com> wrote in message
news:3986d74b.1079486_at_News.CIS.DFN.DE...
> 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.
Received on Tue Aug 01 2000 - 00:00:00 CDT