Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle serveroutput
On Oct 8, 10:27 am, abdoul85 <abdou..._at_gmail.com> 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 ?
No. I suspect you may think you've set serveroutput on, but it really isn't:
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 8 10:47:23 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> set serveroutput on size 2000 format word_wrapped
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('hghg');
3 end;
4 /
hghg
PL/SQL procedure successfully completed.
SQL> Doing as you stated I get output in 10.2. It MIGHT be an issue with 10.2.0.1; check Metalink for any applicable notes.
David Fitzjarrell Received on Mon Oct 08 2007 - 10:50:39 CDT