If I create this type and table:
Code: Select all
drop table type_with_anydata purge;
CREATE OR REPLACE TYPE Cust_Address_Type_ANY
AS OBJECT
( street_address VARCHAR2(40)
, postal_code VARCHAR2(10)
, city VARCHAR2(30)
, state_province VARCHAR2(10)
, country_id CHAR(2)
, new_dev_column CHAR(2)
, something sys.anydata
)
/
create table type_with_anydata
(col1 number,
col2 Cust_Address_Type_ANY);
Insert into TYPE_WITH_ANYDATA
(COL1, COL2)
Values
(1, CUST_ADDRESS_TYPE_ANY('1',NULL,NULL,NULL,NULL,NULL,SYS.ANYDATA.convertVarchar2('This is some data')));
Insert into TYPE_WITH_ANYDATA
(COL1, COL2)
Values
(2, CUST_ADDRESS_TYPE_ANY('1',NULL,NULL,NULL,NULL,NULL,SYS.ANYDATA.convertNumber(1234567890)));
Insert into TYPE_WITH_ANYDATA
(COL1, COL2)
Values
(3, CUST_ADDRESS_TYPE_ANY('1',NULL,NULL,NULL,NULL,NULL,SYS.ANYDATA.convertDate(TO_DATE('01-JAN-2012','DD-MON-YYYY'))));
commit;
Code: Select all
select t.rowid, t.* from type_with_anydata t
"Unknown data type .....\OraObjects.pas, line 2769
Can this be fixed in next version?
I am using Delphi Rad Studio 10.1 Berlin, Oracle 12.2 client and server, ODAC version 10.4.10
Thank you,
John Dorlon