Re: dbms_output.put_line question

From: Janek Metsallik <jan_at_abs.ee>
Date: 1997/08/28
Message-ID: <34051A3A.A4631785@abs.ee>#1/1

Hi Wayne,

> that is how dbms_output works. one of PL/SQL's little quirks!

Don't blame on server, if client is dumb. Try

declare

l_s VARCHAR2(200);
l_n NUMBER;
begin

    dbms_output.put_line('   d');
    dbms_output.get_line(l_s,l_n);
    dbms_output.put_line(length(l_s));
    dbms_output.put_line(l_s);

end;

SQL*Plus eats the spaces in the beginning of the line. Smarter clients, like SQL Navigator, do a better job and reflect the reality.

Regards,
Jan

> > The line:
> >
> > dbms_output.put_line(' text string');
> >
> > produces output which omits the leading blanks. The only solution I
Received on Thu Aug 28 1997 - 00:00:00 CDT