Home » Server Options » Spatial » OCI -> PL/SQL Conversion?
icon5.gif  OCI -> PL/SQL Conversion? [message #161582] Mon, 06 March 2006 02:46 Go to next message
pwab
Messages: 1
Registered: March 2006
Junior Member
Hi All,

I have a component written in c++ and using the OCI api. It is a middle tier component that does the Spatial data manipulation, but it has quite a few problems.

Is it possible to convert this component to use only sql instead of the OCI api? IE: Is there a way to use the spatial functions in a language independant way?

Regards,
Pieter
Re: OCI -> PL/SQL Conversion? [message #172400 is a reply to message #161582] Tue, 16 May 2006 05:54 Go to previous message
benyao68
Messages: 1
Registered: May 2006
Junior Member
Yes. You may refer to Oracle Spatial User's Guide and Reference for more information.

e.g. the following SQL statement

SQL> SELECT count(*)
FROM XYplot_all_wgs84 a, ClimateZone_WGS84 B
WHERE B.objectid = 6
AND SDO_RELATE(A.Shape, B.Shape,
'mask=inside querytype=WINDOW') = 'TRUE';

will return the number of matched rows of A (point) inside B (polygon), where a.shape and b.shape must be stored in the type of MDSYS.SDO_GEOMETRY.

Good luck.
Previous Topic: HOW TO CREATE TRIGGER ON SPATIAL DATA
Next Topic: Getting Errors
Goto Forum:
  


Current Time: Fri Mar 29 03:38:46 CDT 2024