Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Are these "features" or bugs?
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