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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9.2.0.5 SQL-s converted to UPPER case & comments are truncated

Re: 9.2.0.5 SQL-s converted to UPPER case & comments are truncated

From: <J.Velikanovs_at_alise.lv>
Date: Tue, 3 Aug 2004 17:44:41 +0300
Message-ID: <OFF1C6FA6F.C8E6711A-ONC2256EE5.0050E24B-C2256EE5.0051BF8D@alise.lv>


Many thanks Gilles,
.
In case any person interested in issue:
With this fix <event:10946> can be set at level 64 to disable canonicalization and hence retain user comments and white space. eg: Add

     event="10946 trace name context forever, level 64"     into the the init.ora file used to start the instance. .
Jurijs
+371 9268222 (+2 GMT)



Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

gparc_at_free.fr
Sent by: oracle-l-bounce_at_freelists.org
03.08.2004 17:28
Please respond to oracle-l  

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        Re: 9.2.0.5 SQL-s converted to UPPER case & 
comments are truncated

Jurijs,

sorry for a late reply but what you noticed is a consequence of bug #2276769 fixed in 9.2.0.5

See :
http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=2276769.8

HTH Gilles



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Aug 03 2004 - 09:52:52 CDT

Original text of this message

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