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:gabriel_gap_at_yahoo.com]
>
> 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 <Jacques.Kilchoer_at_quest.com>
> 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: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).
Received on Wed Apr 02 2003 - 13:38:59 CST
