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

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle serveroutput

Re: oracle serveroutput

From: <fitzjarrell_at_cox.net>
Date: Mon, 08 Oct 2007 08:50:39 -0700
Message-ID: <1191858639.708319.19300@k79g2000hse.googlegroups.com>


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

Original text of this message

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