Re: PL/SQL problem

Try using
 dbms_output.put_line(chr(10));

Connor McDonald wrote in message <3657AF43.76E6_at_bhp.com.au>...
>Lisa F. Miller wrote:
>>
>> Try
>> dbms_output.put_line(' ');
>>
>> Alvin Huang wrote:
>>
>> > Hi,all
>> >
>> > I got a problem in PL/SQL
>> > how can I put an empty line ....
>> > I tried to use --- dbms_output.new_line,
>> > but it's useless
>> > is there any other functions that I can use to achieve the goal??
>> >
>> > Regards
>> >
>> > Alvin Huang,11/20
>
>I don't think this will work, leading spaces are stripped off using
>dbms_output.put_line
>
>SQL> set serveroutput on
>SQL> exec dbms_output.put_line(' Leading spaces');
>Leading spaces
>
>PL/SQL procedure successfully completed.
>
>SQL>
>--
>==============================================
>Connor McDonald
>BHP Information Technology
>Perth, Western Australia
>"The difference between me and a madman is that I am not mad"
> - Salvador Dali
Received on Sun Nov 22 1998 - 12:27:43 CET