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

Home -> Community -> Mailing Lists -> Oracle-L -> Why dbms_output is not working

Why dbms_output is not working

From: Gabriel Aragon <gabriel_gap_at_yahoo.com>
Date: Wed, 02 Apr 2003 10:55:19 -0800
Message-ID: <F001.00578669.20030402105519@fatcity.com>


I have a very simple code:

begin
dbms_output.enable(1000);
dbms_output.put('hello');
end;

but the dbms_output is not sending the output to the screen. I've already stablished set serveroutput on and also used set serverout on
and still not working, this is a very frequent situation and suddenly it displays everything stored, why is this happening? Is there some buffer that I have to flush with a command? Do I miss something?

TIA
Gabriel Aragon



Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.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 Wed Apr 02 2003 - 12:55:19 CST

Original text of this message

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