 OCI -> PL/SQL Conversion? [message #161582] |
Mon, 06 March 2006 02:46  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
