invokation of serverout in plsql routine.

[SirCharles]

What is syntax for following where is invoked in a procedure
rather than from the sqlplus cli?

set serverout on size 1000000

I've seen this somewhere but don't recall exactly where. I did a search on this forum - probably overlooked entry. I believe I saw sem do this one before.

Thanks,
Charlie
10/4/05

 

[SantaMufasa]

Charles,

The command, "SET SERVEROUT...", is not a PL/SQL command...it is a SQL*Plus command. You cannot invoke that command from a PL/SQL procedure.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[SirCharles]

Hi Dave,
Nice hearing from you.

Yes, I know that is a sqlplus command. I remember seeing the plsql equivalent somewhere.

Charlie

 

[sem]

Actually there's no strict analogue of set serveroutput in pl/sql because this command not only calls dbms_output.[enable|disable] but also makes sql*plus read/not read that buffer upon command completion.

Regards, Dima

http://seminihin.narod.ru

 

[sruff]

DBMS_OUTPUT.ENABLE (1000000);