"Object not allocated" error when editing table with ANYDATA

[jdorlon]

Hello,

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;

When I put this SQL:

Code: Select all

select a.rowid, a.*
from anydata_test a

into a TSmartQuery which attached to a TDBGrid, then try to make an edit in the NUM_COL or VC_COL column in the grid, I get the error: "Object not Allocated" from ODAC and then I cannot edit the table.

I have the latest ODAC version.
Rad Studio 10.1 Berlin
Compiling in 32 bit.
OraCall.OCIUnicode := True;
TOraSession.Options.UseUnicode = true;

Thanks

-John

[MaximG]

We failed to reproduce the issue in our test environment according to your description. Please compose and send a complete test example execution of which reproduces the issue. Please also specify the version and NLS parameters of the Oracle server you use. Please be advised to use the e-support form ( https://www.devart.com/company/contactform.html ) to forward this information to us.

[jdorlon]

OK, I sent a demo app.

[MaximG]

Thank you for the information. We've fixed the issue. The fix is available in the latest ODAC version 10.4.10.