abdoul85 wrote:
> Hello,
> I have question if there are any differences between serveroutput in
> Oracle 9 and 10.
>
> On oracle 9 client // SQL*Plus: Release 9.2.0.1.0 - Production
>
> SQL> BEGIN
> 2 DBMS_OUTPUT.PUT_LINE('hghg');
> 3 end;
> 4 /
> hghg ------ the text appears
>
> But on oracle 10 client // SQL*Plus: Release 10.2.0.1.0 - Production
>
> SQL> BEGIN
> 2 DBMS_OUTPUT.PUT_LINE('hghg');
> 3 end;
> 4 /
> --------- nothing appears :/
>
> In both cases my sql client informs me about correctly executing PL/
> SQL procedure. In both cases:
> serveroutput ON size 2000 format WORD_WRAPPED
>
> What am I doing wrong ? Is tgere any additional option which I have to
> set in oracle 10 client ?
David Fitzjarrell is likely correct in his response but there were
changes to DBMS_OUTPUT in 10g that can be found in the 10g New Features
doc at http://tahiti.oracle.com. The most important relating to the
output buffer size.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Oct 08 2007 - 11:22:28 CDT
