9.2.0.8 issues?

  • From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Sep 2006 10:12:23 +1000

Hi All,



Just wondering if anyone has applied this patch yet and whether there
are any gotchas to watch out for... We upgraded from 9.2.0.6 to 9.2.0.8
and so far have found 3 issues:



1) libraries in lib32 and lib still don't have read and execute
permissions to the world. Problem existed in 9.2.0.7 as well!



2)      SQR failed with ORA-1790 with this simple sql statement:

SELECT :G_InvoiceID

                         FROM DUAL

                         UNION

                         SELECT ss.siteinvoiceid

                         FROM vw_inv_sitesummary ss

                         WHERE ss.invoiceid = :G_InvoiceID



The program compiled fine against the 9.2.0.6 database. We had to do a
TO_NUMBER against the select from DUAL



3)      dbms_stats.export_schema_stats fails with "ORA-06502: PL/SQL:
numeric or value error" if statid had the hyphen or period included, eg.
LENG-20060925 would fail, but LENG#20060925 would work



I've logged an SR about dbms_stats but priority is at a 4, and have not
heard from anyone...



TIA,



Leng.



------------------------------------------------------------------

Leng Kaing

Senior Oracle DBA

Hansen Technologies; 2 Frederick St; Doncaster 3108

Ph: +61-3-9840-3832





Notice:

This e-mail and any attachments are confidential and may contain legally 
privileged information and/or copyright material of Hansen Technologies Limited 
or third parties. Copying, distributing, disclosing, commercialising or 
otherwise acting in reliance on this e-mail and any attachments is strictly 
prohibited unless you are the addressee of this e-mail and have written 
permission to do so. If you have received this e-mail in error please delete 
this e-mail (including any copies and attachments) and contact Hansen 
Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any 
views expressed in this e-mail are those of the individual sender and may not 
necessarily reflect the views of or be a commitment by the organisation, except 
where the individual sender has the authority and expressly states them to be 
so.

Other related posts: