Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Are these "features" or bugs?

Re: Are these "features" or bugs?

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Wed, 12 Jan 2000 11:08:10 -0500
Message-ID: <387CA6EA.EE7EAC6A@Unforgetable.com>


Remco Blaakmeer wrote:
>
> In article <dceh4sk4bjckgkmo6rtjp96vcfg6o14viq_at_4ax.com>,
> Walter Dnes <waltdnes_at_waltdnes.org> writes:
> > 1) The PL/SQL output procedure DBMS_OUTPUT.PUT_LINE() appears to
> > do an implicit LTRIM() on output. E.g. the string ' XX' is output
> > as 'XX'. This really mucks up attempts to output reports in neat
> > columns. I've resorted to putting leading dots at the beginning
> > of the line to force proper alignment. Is there such an animal as
> > a "non-breaking-space" ?
> > BTW, lines consisting entirely of spaces don't get printed at all.
> > Not even a line feed!
>
> This is a bug in sqlplus, actually. But you can work around it. Just
> insert whatever you would like to give as output into a table and later
> on, select everything from that table. You could use a table like this:
>

This is not a bug. That is the way it is supposed to work and it is documented as such. Users are free to apply whatever workout they need, but just because it doesn't work the way we would like it to work doesn't mean that it is a bug. Received on Wed Jan 12 2000 - 10:08:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US