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 -> oracle serveroutput

oracle serveroutput

From: abdoul85 <abdoul85_at_gmail.com>
Date: Mon, 08 Oct 2007 08:27:03 -0700
Message-ID: <1191857223.282605.171260@k79g2000hse.googlegroups.com>


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 /

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 ? Received on Mon Oct 08 2007 - 10:27:03 CDT

Original text of this message

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