Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> turning off verbose output of pl/sql?

turning off verbose output of pl/sql?

From: Robert William Vesterman <bob.work_at_vesterman.com>
Date: 2000/08/01
Message-ID: <3986d74b.1079486@News.CIS.DFN.DE>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US