I have this table:
Code: Select all
CREATE TABLE ANYDATA_TEST
(
NUM_COL NUMBER,
VC_COL VARCHAR2(100),
ANYDATA_COL SYS.ANYDATA
);
insert into anydata_test
(num_col, vc_col, anydata_col)
values
(1, '1', SYS.ANYDATA.convertVarchar2('test'));
insert into anydata_test
(num_col, vc_col, anydata_col)
values
(2, '2', SYS.ANYDATA.convertNumber(2));
insert into anydata_test
(num_col, vc_col, anydata_col)
values
(3, '3', SYS.ANYDATA.convertDate(sysdate));
commit;
Code: Select all
select a.rowid, a.*
from anydata_test a
I have the latest ODAC version.
Rad Studio 10.1 Berlin
Compiling in 32 bit.
OraCall.OCIUnicode := True;
TOraSession.Options.UseUnicode = true;
Thanks
-John