RE: 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: 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 to
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 as well!


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


                         FROM DUAL


                         SELECT ss.siteinvoiceid

                         FROM vw_inv_sitesummary ss

                         WHERE ss.invoiceid = :G_InvoiceID


The program compiled fine against the 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...







Leng Kaing

Senior Oracle DBA

Hansen Technologies; 2 Frederick St; Doncaster 3108

Ph: +61-3-9840-3832


Other related posts: