Re: DBMS_OUTPUT questions

From: Andrew Allen <andrew.allen_at_handleman.com>
Date: Mon, 17 Feb 2003 15:35:07 GMT
Message-ID: <3E50F41F.1090906_at_handleman.com>

Code Monkee wrote:

> I stand corrected! Us newbies are a sorry lot indeed.
> 
> How can I view the debug info generated by DBMS_OUTPUT statements that are
> part of Oracle 8i PL/SQL stored procedures that are executing on a Dell
> Server with dual 550 Mhz processors and 4GB of memory, running MS Windows
> 2000 Server version 5.0.2195 Service Pack 2 Build 2195?

SQL> set serverouput on

SQL> exec dbms_output.enable(1000000);
SQL> <run your pkg with embedded dbms_output.put_line() statements here;

> 
> Also, where can I find more detailed info on what specific service
> pack/patch level of Oracle 8i I'm running?

SQL> select banner from v$version;
Check your release documentation for how the version number breaks down.   Oracle changed it in Vs. 9.

--
Andrew Allen

> 
> "Bert Bear" <bertbear_at_NOSPAMbertbear.net> wrote in message
> news:bFe3a.179$nk2.97284257_at_newssvr11.news.prodigy.com...
> 


>>Code,


>>

>>What version of Oracle, hardware, operating system version, etc.?  Are you

>>discussing Oracle 9i or Oracle release 5?  There are many differences

>>between the two.

>>

>>My crystal ball says you are on a beta copy of Oracle 6.X and on a PC

>>running MS-OS/2 version 2.1.  Am I right?!  Yup, thought so!  See, my

> 
> point
> 


>>is simple:  We only know what you tell us, everything else is an


> 
> assumption.
> 


>>Back to your question, assuming I understand it and your situation


>>correctly:

>>

>>1)    "set serveroutput on" enables DBMS_OUTPUT at the SQL*PLUS command

>>level - not the database nor at the session level.

>>

>>2)    You need to reconsider the question, as "set serveroutput" doesn't

>>deal with the database only with SQL*PLUS.  Think about "What are you

>>wanting to accomplish (instead of suggesting ways to accomplish it)?"

>>

>>Bertram Moshier

>>Oracle Certified Professional 8i and 9i DBA

>>

>>http://www.bmoshier.net/bertram

>>

>>

>>"Code Monkee" <monkee_at_monkeebusiness.com> wrote in message

>>news:nVCdnQeRKIgy7NCjXTWc2Q_at_giganews.com...

>>

>>>Newbie questions:

>>>

>>>1) If I issue a "set serveroutput on" command from a sqlplus session

>>

> does
> 


>>>this enable DBMS_OUTPUT for the session only, or does it affect the


>>

> entire
> 


>>>DB?

>>>

>>>2) When I "set serveroutput on" I can see DBMS_OUTPUT for any PL/SQL

>>>procedures I invoke in sqlplus. How can I "set serveroutput on" for the


>>>entire DB, and where would I see the DBMS_OUTPUT?

>>>

 

Received on Mon Feb 17 2003 - 16:35:07 CET