RE: Why dbms_output is not working

You need a dbms_output.put_line to "complete" the output line. e.g.
SQL> set serveroutput on
SQL> begin
  2 dbms_output.put ('Hello') ;
  3 end ;
  4 /
Procedure PL/SQL terminee avec succes.

SQL> begin
  2 dbms_output.put_line ('Bonjour') ;   3 end ;
  4 /
HelloBonjour
Procedure PL/SQL terminee avec succes.

> -----Original Message-----
> From: Gabriel Aragon [mailto:gabriel_gap_at_yahoo.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?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.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).