Re: ADO and Oracle Spatial

"Robert Wehofer" <wehofer_at_gisquadrat.com> wrote in message news:<RTAL9.56218$TA6.680158_at_news.chello.at>...
>
> The resulting types of the statement are all of basic types like integer or
> float. The Oracle Spatial function sdo_geom.sdo_area returns a field of type
> float. The error is not raised by the ADO protocol but in Oracle itself.
> Propabably ADO is not able to send the statement correctly to the Oracle
> Server.

OK, I missed that (should have looked up what the Spatial function actually returned). I'm assuming that in your actual code, there's a quote in front of MyTable, so this isn't just a syntax error.

For kicks, can you put your SQL statement in a stored procedure and call the stored procedure? I don't think there would be anything in your SQL statement that the OLE DB provider would try to muck with, but a procedure call would definitely prevent that.

Also, which OLE DB provider are you using?

Justin

>
> Robert
>
> "Justin Cave" <jocave_at_yahoo.com> schrieb im Newsbeitrag
> > 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
Received on Tue Dec 17 2002 - 18:37:48 CST