Re: dbms_output.put_line question

In 7.3.3 you can use the command

set serverout on size 1000000 format wrapped

but I guess that isn't much use to you on v7.1.4

What I have tended to do on that version is either use chr(9) to print a preceeding tab or chr(1) to print a non-printable character (this may not always be non-printable on some machines) to stop dbms_output from ltrimming leading spaces.

e.g.

dbms_output.put_line(chr(9)||' text string');

Hope this helps,

Ian Received on Wed Aug 20 1997 - 00:00:00 CDT