Title: 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:[EMAIL PROTECTED]]
>
> 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?

Reply via email to