<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<small><font size="+1"><small>Hi List,<br>
<br>
<br>
<br>
I was looking for parameter syntax when using native Oracle support.<br>
I found in the documetation a PDF from 2004 or 5 telling all about
FUNCTION and VERSION, but i couldn';t get it right and was very unhappy
about it<br>
<br>
But then i looked in the source file (maporaclespatial.c) and found
the follwing short notice<br>
</small></font><font size="+1"><small><tt>*****************************************************************************<br>
*<br>
* Using OracleSpatial:<br>
* - CONNECTIONTYPE oraclespatial<br>
* - CONNECTION 'username/password@database'<br>
* - DATA 'geometry_column FROM <table>'<br>
* or<br>
* DATA 'geometry_column FROM <table> [USING UNIQUE
<column>' SRID #srid <function> VERSION <vcode>]'<br>
* <function> can be:<br>
* 'FILTER', 'RELATE', GEOPMRELATE' or 'NONE'<br>
* <vcode> can be:<br>
* '8i', '9i' or '10g'<br>
* <br>
* <table> can be:<br>
* One database table name<br>
* or:<br>
* (SELECT stmt)<br>
*<br>
*****************************************************************************<br>
* Notices above shall be included in all copies or portions of the
software.<br>
* This piece is provided "AS IS", without warranties of any kind. Got
it?<br>
*****************************************************************************</tt></small></font><font
size="+1"><small>/ <br>
<br>
<br>
<br>
Looks clear to me, and surprizingly it answered all my questions to
satisfaction.<br>
So, please </small></font></small><small><font size="+1"><small>
whoever manages that part now, </small></font></small><small><font
size="+1"><small>start the extensive PDF help info with this.<br>
<br>
Regards, Huub<br>
<br>
<br>
p.s. i have a small extra:<br>
<br>
In <br>
* DATA 'geometry_column FROM <table><br>
<br>
<table> can or sometimes must be a select query in brackets <br>
<br>
e.g.<br>
<br>
SELECT geom FROM (select geom,id from geo_table) USING UNIQUE id SRID
123123 RELATE VERSION 10g<br>
<br>
</small></font></small>
</body>
</html>