Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sending feed back to sqlplus user

RE: Sending feed back to sqlplus user

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 26 Aug 2006 17:14:54 +0800
Message-id: <00ca01c6c8f0$17fc8850$6501a8c0@windows01>


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-l
Received on Sat Aug 26 2006 - 04:14:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US