Re: PL-SQL Blank-Lines
Date: 1996/04/07
Message-ID: <4k8s4h$sim_at_nntp.interaccess.com>#1/1
Wachs Rene <Rene.Wachs_at_ezv.admin.ch> wrote:
Have you tried doing something like this:
DBMS_OUTPUT.PUT_LINE(CHR(255)); to output a non-printing (and also non-space) ascii code?
I had a similar problem with this package some time ago. From SQL*PLUS all leading spaces are trimmed (not so from SQL*DBA.) I called in a TAR and Oracle claims that trimming the spaces makes sense (though they could never convincingly explain why.) Anyhow, if you're going to use DBMS_OUTPUT be prepared to end up with tons of bubble gum and bailing wire...:~-(
>Hello
>To solve many problems, I have to use PL/SQL. For example, I have to generate
>an output like this :
> Line 1
> Line 2
> Line 3
> Line 4
> Line 5
> Line 6
> Line 6
>
> Line 7
> Line 8
> ... etc
>It's a MUST to insert blank-Lines between certain Records. To display these
>records I use the dbms_output-Package. It works fine, but the command
> dbms_output.put_line(' ') ;
>for insert a blank-Line is ignored by PL/SQL.
>Question : how to insert a blank-line in PL/SQL (with the dbms_output-Pck.) ?
>Any HELP is very appreciated. Thanks
>R. Wachs
Received on Sun Apr 07 1996 - 00:00:00 CEST