OraFAQ Forum: Client Tools » dbms_output.put

Home » SQL & PL/SQL » Client Tools » dbms_output.put_line

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_output.put_line [message #416709]

Tue, 04 August 2009 01:07

suhasbr
Messages: 23
Registered: April 2008
Location: Chennai

Junior Member

Hi Gurus,

I have a SQL file in which i display an empty line before the Actaul data line. which would be soem thing like

DBMS_OUTPUT.PUT_LINE(' ');
DBMS_OUTPUT.PUT_LINE('--- Contact IS.');
DBMS_OUTPUT.PUT_LINE(' ');

This code is not working. Can any one help me out....

Thanks in advance

Report message to a moderator

Re: dbms_output.put_line [message #416712 is a reply to message #416709]

Tue, 04 August 2009 01:13

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

What do you mean by not working?
We can't read your mind.

By
Vamsi

Report message to a moderator

Re: dbms_output.put_line [message #416715 is a reply to message #416712]

Tue, 04 August 2009 01:24

suhasbr
Messages: 23
Registered: April 2008
Location: Chennai

Junior Member

I am unable to get the output in this desired fashion

<Empty line>
Conatct IS
<Empty line>

I am thinking to assign a variable NULL value and print it. But is there any other way other than this?

Report message to a moderator