"Object not allocated" error when editing table with ANYDATA

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jdorlon
Posts: 139
Joined: Fri 05 Jan 2007 22:07

"Object not allocated" error when editing table with ANYDATA

Post by jdorlon » Wed 17 Apr 2019 19:50

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
Devart Team
Posts: 1487
Joined: Mon 06 Jul 2015 11:34

Re: "Object not allocated" error when editing table with ANYDATA

Post by MaximG » Fri 26 Apr 2019 15:17

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
Posts: 139
Joined: Fri 05 Jan 2007 22:07

Re: "Object not allocated" error when editing table with ANYDATA

Post by jdorlon » Mon 29 Apr 2019 21:21

OK, I sent a demo app.

MaximG
Devart Team
Posts: 1487
Joined: Mon 06 Jul 2015 11:34

Re: "Object not allocated" error when editing table with ANYDATA

Post by MaximG » Fri 12 Jul 2019 16:43

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

Post Reply