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
memory problems using new direct mode with objects
Re: memory problems using new direct mode with objects
Hello,
Please send a table creating script.
Please send a table creating script.
Re: memory problems using new direct mode with objects
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
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
Re: memory problems using new direct mode with objects
Please send the script for filling in your table (which opening causes the "out of memory" error) to alexp*devart*com
Re: memory problems using new direct mode with objects
To save time I will use OCI mode.
Stefan
Stefan
Re: memory problems using new direct mode with objects
Unfortunately, without reproducing the problem, we can't help you solve it.