Re: dbms_output

From: Gabriel Aragon <gabriel_gap_at_yahoo.com>
Date: Fri, 16 May 2003 08:56:53 -0800
Message-ID: <F001.0059AD21.20030516085653@fatcity.com>

Matthew, if you have a code like:

.
.
begin

dbms_output.enable(10000);
dbms_output.put_line('whatever');
.
.
dbms_output.disable; -- remove this line so you can see the output

end;

Also be sure the code is getting into the function, check the logic.

Gabriel

• "Adams, Matthew (GECP, MABG, 088130)" <MATT.ADAMS_at_APPL.GE.COM> wrote:
  > If I have put 'dbms_output.enable(10000)'
  > and dbms_output.put_line('hello world')
  > in a function (contained in a package)
  > and run 'set serveroutput on' in sqlplus,
  > and then call the function in a select statement,
  > what reasons might there be for not getting the
  > output
  > to my screen?
  >
  > The statement does not return any error?
  >
  > The manual for built in packages (8.1.6) gives
  > no indications as to why this might not work from a
  > package.
  >
  > ----
  > Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
  > When someone says "I want a programming language in
  > which I
  > only need say what I want done", give him a
  > lollipop.
  >
  

  ---

"Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier

---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: gabriel_gap_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri May 16 2003 - 11:56:53 CDT