How to run & view the out put of procedures in SQL:\>

[sunarb]

i dont know how to run and view the out of the procedures created in sql command prompt in windows xp.please guide me.
ex:how to view the out put of dbms_output.put _line("Hello"); on the sql command prompt.

[QVeen72]

Hi,

Open the SQL Worksheet,
Type this :

SET SERVEROUTPUT ON;
dbms_output.put _line('Hello');

and Execute it..


Regards
Veena

[amitpatel66]

You will need to run this SET command to view the output of dbms_output package;

[code=oracle]
SQL> SET SERVEROUTPUT ON
SQL>

<now you execute your pl/sql code>

[/code]