Re: PL/SQL : serveroutput on inside begin..end block Possible ? Impossible??

"baka" <mesundara_at_hotmail.com> wrote in message news:1120637544.661569.158750_at_g43g2000cwa.googlegroups.com...
| Thanks for your quick reply.
|
| I think DBMS_OUTPUT.ENABLE will only enable the buffer size,
| it does not provide the facility of printing on the terminal? And
| only sqlplus command " Set serverouput on size 10000...."
| will hit the two birds in one stone. i.e setimng the buffer size
| and printing it on the screen.
|
| Any more suggestion Please?

Yes - You could add the functionality you require in one of the following Oracle startup scripts:

1. login.sql Or...
2. glogin.sql

Read up on the difference between the two.

Cheers,
Chris Val Received on Wed Jul 06 2005 - 05:08:21 CDT