Devart Forums

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

Hello,

Please send a table creating script.

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

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

To save time I will use OCI mode.

Stefan

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