9.2.0.8 issues?

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.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 25 2006 - 19:12:23 CDT