Error Generating shape

[TonyGroeneveld]

I'm using the sde.st_intersects function in an Oracle update statement in an Oracle package.  I run the code successfully, updates ~ ~17,000.  Data is committed.  Run it again same data works fine.  Run it a third time and get the following error:
[INDENT]ORA-20011: Error generating shape. (SHAPE2)
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 170
ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 326 at ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 170[/INDENT]


I then disconnect from the database and reconnect and I'm able to successful run the code twice again and it errors out on the third time.

Something must be filling up that stops the function from generating shape on the third run, and is released when you disconnect.

Any help on this matter would be appreciated.
Thanks.

[VinceAngelo]

Sounds like a memory leak.  What version of Oracle are you using (A.B.C.D notation)?
What version of ArcSDE is installed (M.m spN notation)?

This is generally the sort of problem best dealt with directly via Tech Support.  They'll
need a copy of your data to reproduce the issue.

- V

[TonyGroeneveld]

The versions are
�?� The SDE version is 10 SP5
�?� Red Hat Enterprise Linux AS release 4 (Nahant Update 9)
�?� Oracle Database 10g Release 10.2.0.3.0