Re: ADO and Oracle Spatial

"Robert Wehofer" <wehofer_at_gisquadrat.com> wrote in message news:<QamL9.48461$TA6.547686_at_news.chello.at>...
> Has anyone tried out to execute Oracle Spatial functions via ADO?

I don't believe that ADO provides methods to return any sort of object type, spatial included. Generally, Microsoft protocols like ADO don't provide support for Oracle specific types & constructs.

Justin Cave

>
> I'm using Oracle 8i and I want to execute an SQL statement with geometry
> areas as result:
>
> SELECT ID,sdo_geom.sdo_area(base.SDOGEOMETRY,meta.diminfo) AS SDOArea
> FROM MyTable base,USER_SDO_GEOM_METADATA meta
> WHERE meta.table_name=MyTable' AND meta.column_name='SDOGEOMETRY'
>
> This statement is executed correctly in Oracle Worksheet, but if I execute
> the statement via ADO (that works!) and, then, read out the number of
> datasets with RecordCount, I get the error message:
>
> ORA-13050: Unable to construct spatial object
> ORA-06512: at "MDSYS.SDO_3GL", line 399
> ORA-06512: at "MDSYS.SDO_GEOM", line 3441
> ORA-06512 at line 1
>
> The interesting point of view is, that the recordset object is able to
> define correct field objects (the field types are ok!), but as soon as I try
> to address the datasets (with RecordCount or navigation methods like
> MoveNext), an error is raised.
>
> What can I do to calculate areas via ADO?
>
> Regards,
> Robert
Received on Mon Dec 16 2002 - 16:32:58 CST