topic Re: dbms_output in Operating System - HP-UX

dbms_output

John Flanagan — Mon, 09 Feb 2004 04:49:47 GMT

Is it possible to use dbms_output.put_line to print a blank line?

also

When outputing a data line can this start with spaces?

Regards,

John.

Re: dbms_output

Yogeeraj_1 — Mon, 09 Feb 2004 07:07:26 GMT

hi,

use chr(10) for blank lines...
Tried these:

yd@MYDB.MU> exec dbms_output.put_line('Hello');
Hello

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.94
yd@MYDB.MU> exec dbms_output.put_line(chr(10)||'Hello'||chr(10));

Hello

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00
yd@MYDB.MU>

hope this helps!

regards
Yogeeraj

Re: dbms_output

Graham Cameron_1 — Mon, 09 Feb 2004 07:18:27 GMT

John

Blank lines can be done just with

dbms_output.put_line('') ;

If you want to use leading spaces, you need to specify FORMAT WRAP before firing off the pl/sql

eg
SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAP

-- Graham

Re: dbms_output

Yogeeraj_1 — Mon, 09 Feb 2004 07:20:41 GMT

hi again,

for leading spaces, the best i could do till now is:

yd@MYDB.MU> exec dbms_output.put_line('.'||' '||'Hello');
. Hello

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.48

working on it

regards
Yogeeraj

Re: dbms_output

John Flanagan — Mon, 09 Feb 2004 09:13:18 GMT

Hi,

The only solution that seems to work is '.'. I have been using this but it does not give the best output. The chr(10) solution seems to skip 2 lines.

Regards,

John.

Re: dbms_output

R. Allan Hicks — Mon, 09 Feb 2004 20:45:47 GMT

If you don't mind the ringing in your ears, you might try this....

1 begin
2 dbms_output.enable(200000);
3 dbms_output.put_line('Line 1');
4 dbms_output.put_line(chr(7));
5 dbms_output.put_line('Line 2');
6* end;
SQL> /
Line 1

Line 2

PL/SQL procedure successfully completed.

SQL>

The chr(7) is the bell character which won't print and should be benign to most printers and terminals. You could try some other unprintable characters like chr(1) stx if memory serves. It didn't bother my hpterm emulator.

good luck