memory problems using new direct mode with objects

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

memory problems using new direct mode with objects

Post by Aufhauser » Mon 27 Apr 2015 07:33

Hi,
I have problems using new version of ODAC direct mode with spatial objects. On principle my program works, but just browsing a table whith more then about 300 records causes my program to crash whith "out of memory".
[code]
Query.SQL.Add('Select ID, GEOMETRY from NF_KF');
Query.Active;
While not Query.EOF
Query.Next;
[/code]
Stefan

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: memory problems using new direct mode with objects

Post by AlexP » Mon 27 Apr 2015 08:28

Hello,

Please send a table creating script.

Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

Re: memory problems using new direct mode with objects

Post by Aufhauser » Tue 28 Apr 2015 05:19

It is not a data-problem, so you can use oracle demo data.
Or you can create a single table and fill it with oracle-demo-scripts.

CREATE TABLE KG_KF
(
GDO_GID NUMBER(38),
SDOGEOMETRY MDSYS.SDO_GEOMETRY,
CONSTRAINT PK_KG_KF PRIMARY KEY(GDO_GID)
);

Stefan

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: memory problems using new direct mode with objects

Post by AlexP » Tue 28 Apr 2015 08:25

Please send the script for filling in your table (which opening causes the "out of memory" error) to alexp*devart*com

Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

Re: memory problems using new direct mode with objects

Post by Aufhauser » Thu 14 May 2015 05:31

To save time I will use OCI mode.

Stefan

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: memory problems using new direct mode with objects

Post by AlexP » Tue 19 May 2015 08:29

Unfortunately, without reproducing the problem, we can't help you solve it.

Post Reply