6 Replies Latest reply on Apr 22, 2015 9:46 PM by krissco

    4.1 EA2 Bug Report: ORA-01460 in 9iR2 database when expanding "Views" node.

    krissco

      I'm getting the following error in 4.1 EA2 when expanding the Views node on a 9iR2 database:

      ORA-01460: unimplemented or unreasonable conversion requested

      01460. 00000 -  "unimplemented or unreasonable conversion requested"

      *Cause:   

      *Action:

      Vendor code 1460

       

      From the Statements - Log I can see the query is:

      select * from ( SELECT OBJECT_NAME, OBJECT_ID, '' short_name,
                   DECODE(STATUS, 'INVALID', 'TRUE', 'FALSE') INVALID, OWNER OBJECT_OWNER, CREATED, LAST_DDL_TIME
        FROM SYS.Dba_OBJECTS
        WHERE OWNER = :SCHEMA
        AND OBJECT_TYPE = :TYPE
        AND   SUBOBJECT_NAME IS NULL
        union all
        SELECT OBJECT_NAME, OBJECT_ID , syn.SYNONYM_NAME short_NAME,
                   DECODE(STATUS, 'INVALID', 'TRUE', 'FALSE') INVALID, SYN.TABLE_OWNER OBJECT_OWNER, O.CREATED, O.LAST_DDL_TIME
                     FROM SYS.Dba_OBJECTS O, sys.user_synonyms syn
                     WHERE  syn.table_owner = o.owner
                     and    syn.TABLE_NAME = o.object_NAME
                     and    o.object_type = :TYPE
                     and :INCLUDE_SYNS = 1
        AND   SUBOBJECT_NAME IS NULL
        )
      

       

      And the binds are:

      "SCHEMA"="CUSTOM", "TYPE"="VIEW", "INCLUDE_SYNS"=null