RE: 9.2.0.8 issues?
- From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Sep 2006 10:38:51 +1000
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@xxxxxxxxxxxxx'
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
Other related posts:
