RE: 9.2.0.8 issues?

Actually, problem #3 has been identified as bug 5548043 - 'STATID is intended to be an "identifier" type parameter but the value passed in here is not a valid identifier

and so reports ORA-6502 in 9.2 and ORA-20001 "xxx is an invalid identifier" in 10.2 '  

So how do you go about finding out about valid vs invalid identifiers?  

From: Leng Kaing
Sent: Tuesday, 26 September 2006 10:12 AM To: 'oracle-l_at_freelists.org'
Subject: 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  

--

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