Re: dbms_output.put_line question

Hi Alan,    

   I solved your problem. Check the ASCII code chart, ctrl_i is tab. Its value is 9, cat this with your text. This is what I've got:    

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

        text string

PL/SQL procedure successfully completed.

-- 
Bob
Gator Bait Software

spam-offAlan Long <TICS28_at_email.mot.com> wrote in article
<TICS28-1808971225570001_at_tics28.sps.mot.com>...


> The line:

> 

>             dbms_output.put_line('     text string');

> 

> produces output which omits the leading blanks. The only solution I have

> found is to include a leading period:

> 

>             dbms_output.put_line('.     text string');

> 

> This seems a bit dumb, uses up one column of output, and looks untidy. Is

 there


> a better way?

> 

> I'm using Oracle 7.1.4 and PL/SQL 2.1.4

> 

> -- 

> Alan Long

> Materials Systems Group

> Motorola, East Kilbride, Scotland

> email tics28@"spam-off"email.mot.com (remove the "spam-off")

>