Re: PL-SQL Blank-Lines

In article <1996Mar28.150005.951_at_gw2.admin.ch>, Wachs Rene <Rene.Wachs_at_ezv.admin.ch> writes:
|> 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
|>
The blank lines are in fact being inserted, but SQL*Plus is stripping them. This behavior actually comes from the word wrapping feature of SQL*Plus. I believe that Plus 3.3 will have a new column option which fixes it. Try running your program from SQL*DBA to see what I mean. As an alternate workaround, you can try outputing a non-blank character as the first character of the line (such as a dash) or putting in a chr(10) which is a carriage return.

-- 
Scott Urman
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"