XMLType

[w]

Hi,

DOA 4.1.0
Delphi 7
Oracle 10.2.0.1

When I try to execute the "select * from XDB.XDB$ANY" query i get the "ORA-30757: cannot access type information" error.

How can I solve this problem?

CREATE TABLE "XDB"."XDB$ANY" OF "SYS"."XMLTYPE"
   (    REF ("XMLDATA"."PROPERTY"."PARENT_SCHEMA") WITH ROWID,
    REF ("XMLDATA"."PROPERTY"."SMPL_TYPE_DECL") WITH ROWID,
    REF ("XMLDATA"."PROPERTY"."TYPE_REF") WITH ROWID,
    REF ("XMLDATA"."PROPERTY"."PROPREF_REF") WITH ROWID
   )
  XMLSCHEMA "http://xmlns.oracle.com/xdb/XDBSchema.xsd" ELEMENT "any" ID 127
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "SYSAUX";

 

[Marco Kalter]

Can you let me know your exact Oracle Client version?

 

[w]

Client and server at the same machine...

SQL> SELECT banner FROM v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

 

[w]

Do you have any idea?

 

[Marco Kalter]

Not yet, but we have been able to reproduce this.