Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sending feed back to sqlplus user
Btw,
you could also use dbms_output.get_lines to fetch the rows into sqlplus
variables and print them.
This is what sqlplus is doing after executing each pl/sql block when
serveroutput is on - executing dbms_output.get_lines and displaying their
return values...
But you would need to put this into all your clients (g)login.sql as well, thus it's not much different from the solution suggested below by Ghassan..
Tanel.
SQL> begin
2 dbms_output.enable(10000);
3 dbms_output.put_line('test before');
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> set serverout on size 10000
SQL> begin null; end;
2 /
test before
PL/SQL procedure successfully completed.
so 'set server...' does not clear the buffer if already set before, so for
sql*plus,
you can change your glogin.sql to insert
set serveroutpout on size .....
begin
null;
end;
/
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 26 2006 - 04:14:54 CDT
![]() |
![]() |