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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL : serveroutput on inside begin..end block Possible ? Impossible??

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

From: baka <mesundara_at_hotmail.com>
Date: 6 Jul 2005 01:12:24 -0700
Message-ID: <1120637544.661569.158750@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?



Thnaks in Advance.
Received on Wed Jul 06 2005 - 03:12:24 CDT












Original text of this message













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