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@xxxxxxx Sent by: oracle-l-bounce@xxxxxxxxxxxxx 03.08.2004 17:28 Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------