SERVEROUTPUT in procedure

[Deepa More]

I have converted a PL/SQL block to procedure, it outputs the result for every record on screen so to maximize buffer size

  SET SERVEROUTPUT ON SIZE 1000000  

was used. Question is Can we invoke above statement in procedure as whenever it is exceuted it will set size internally or is there any other way?

Thanks
Deepa

[Jan Cumps]

set serverout is not a pl/sql command.
It's an SQL*Plus instruction.
This means that you change SQL*/Plus's behaviour. Nothing happens on the database server.
Your database does not understand this command. It can't be used in pl/sql.

Have a look at the dbms_output and fnd_file packages. They allow you to output text/data from within a pl/sql package.

Regards, Jan