Don't know what to tell you. I don't remember ever seeing output disappear if you use dbms_output.put_line.
Of course you have to remember to say
set serveroutput on size N
where N is the number of bytes that will be output
and if you are doing this in SQL*Plus you need to reissue the "set serveroutput" statement after each connect. Could that be the problem? You connected to a different database and then the output was no longer displayed?
> -----Original Message-----
> From: Gabriel Aragon [mailto:[EMAIL PROTECTED]]
>
> Nope, I've already did it, first using put and then
> put_line, and sometimes I can see the output like you
> did, but sometimes I use de put_line without a
> previous put and it doesn't work! This is nonsense!
>
> I also use the dbms_output.enable(somevalue) with the
> same frustrating result. Any other idea? I dont wnt to
> write the code to send the output to a file.
>
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> > 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?
