Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ST_GEOMETRY Support in .net

720539Sep 2 2009 — edited Sep 3 2009
Hi I am using .net 2.0. I am trying to run a database query from my .net application. I need to select the ST_geometry from the table. By using
System.Data.OracleClient or Oracle.DataAccess, I get error message "Unsupported Column Datatype".
Any suggestions what .net namespace I should be using to return the ST_Geometry field in my datatable

select a.NAME, a.ADDRESS_DETAIL, a.STREET_NAME, a.LOCALITY, a.POST_CODE
from
(select * from GIS_OWNER.POI_ALL a where
sde.st_within (a. shape, sde.st_polyfromtext ('polygon ((181262.568304515 597938.283887471,181262.568304515
737638.56328803,450608.940330592 737638.56328803,450608.940330592 597938.283887471,181262.568304515
597938.283887471))', 2))=1) p,

(select * from GIS_OWNER.DYNAMIC_COVERAGE_4 a where
sde.st_within (a. shape, sde.st_polyfromtext('polygon ((181262.568304515 597938.283887471,181262.568304515
737638.56328803,450608.940330592 737638.56328803,450608.940330592 597938.283887471,181262.568304515
597938.283887471))', 2))=1) q

where
sde.ST_intersects(p.shape,q.shape) =0;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2009
Added on Sep 2 2009
4 comments
1,708 views