<html>
<head>
</head>
<body style="margin-top: 4px; line-height: normal; margin-bottom: 1px; font-variant: normal; margin-right: 4px; margin-left: 4px">
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">All,</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">I've had some experience here. The two modes of operation that are described are an accurate representation of the Oracle world. I would suggest at least including a descriptive difference in any sort of work order put out. There will likely need to be two separate modes of operation available (spatially). If you are building a true Oracle connector, you may want to even think of it as three separate modes, since a straight tabular linking is also a likely valuable addition. Connecting Oracle tabular data to Spatial constructs would be a usable business tool for many.</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<br>
<br>
>>> <jonathanmoules@warwickshire.gov.uk> wrote:<br> </p>
<table style="margin-top: 0; margin-bottom: 0; margin-right: 0; margin-left: 15px; font-size: 1em" border="0" bgcolor="#f3f3f3">
<tr>
<td>
<div style="padding-left: 7px; border-left: solid 1px #050505">
<p style="margin-top: 0; margin-bottom: 0">
<font face="Arial" size="3">I don't know much about Oracle either, only what I've had the misfortune to glean from trying to work with it.</font><br><font face="Arial" size="3">I raised it because due to the way that Oracle license, its easy to accidentally use Oracle Spatial functions when you only want to use Oracle Locator (which is a subset of Oracle Spatial functions).</font><br><font face="Arial" size="3">There are some pages that compare the two:</font><br><font face="Arial" size="3"><a href="http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator-vs-enterprise-licensing-the-sdogeom-package/">http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator-vs-enterprise-licensing-the-sdogeom-package/</a></font><br><font face="Arial" size="3"><a href="http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_locator.htm">http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_locator.htm</a></font><br><br><font face="Arial" size="3">I think from a driver perspective they're identical, but that QGIS shouldn't use any of the Spatial functions unless the user explicitly asks it to.</font><br><br><font face="Arial" size="3">Jonathan</font><br><br><br><br><br><font color="#5f5f5f" size="1" face="sans-serif">From: </font><font face="sans-serif" size="1">Andreas Neumann <a.neumann@carto.net></font><br><font color="#5f5f5f" size="1" face="sans-serif">To: </font><font face="sans-serif" size="1">"G. Allegri" <giohappy@gmail.com></font><br><font color="#5f5f5f" size="1" face="sans-serif">Cc: </font><font face="sans-serif" size="1"><jonathanmoules@warwickshire.gov.uk>, <qgis-user@lists.osgeo.org>, <qgis-developer@lists.osgeo.org></font><br><font color="#5f5f5f" size="1" face="sans-serif">Date: </font><font face="sans-serif" size="1">03/04/2012 10:35</font><br><font color="#5f5f5f" size="1" face="sans-serif">Subject: </font><font face="sans-serif" size="1">Re: [Qgis-user] Oracle Spatial Driver</font><br><hr noshade="noshade"><br><br><br><tt><font size="2"> Hi,<br style="font-size: 2"><br style="font-size: 2">Shouldn't the Oracle driver work for both versions? I would assume so,<br style="font-size: 2">but I may be wrong ... To me (not an oracle specialist) it seems like<br style="font-size: 2">this is only a licensing difference?<br style="font-size: 2"><br style="font-size: 2">Thanks for clarifying,<br style="font-size: 2">Andreas<br style="font-size: 2"><br style="font-size: 2">On Tue, 3 Apr 2012 11:27:26 +0200, G. Allegri wrote:<br style="font-size: 2">> I suppose we're talking about Oracle Spatial, otherwise I don't think<br style="font-size: 2">> it would worth it...<br style="font-size: 2">><br style="font-size: 2">> giovanni<br style="font-size: 2">><br style="font-size: 2">> 2012/4/3<br style="font-size: 2">><br style="font-size: 2">>> Just a quick general question - would this be an Oracle Spatial or<br style="font-size: 2">>> an Oracle Locator driver? Because (for those who don't know), Oracle<br style="font-size: 2">>> give quite a lot of their spatial stuff for "free" by way of Oracle<br style="font-size: 2">>> Locator (it's included in Oracle Enterprise Edition), but there's a<br style="font-size: 2">>> expensive extension called Oracle Spatial which adds a lot more<br style="font-size: 2">>> functions.<br style="font-size: 2">>><br style="font-size: 2">>> Ideally the driver would be able to use the Locator functionality<br style="font-size: 2">>> without triggering the Spatial functionality unless that<br style="font-size: 2">>> functionality is explicitly requested (Oracle have a weird licensing<br style="font-size: 2">>> model - everything is enabled and you can't easily disable it; the<br style="font-size: 2">>> onus is on the user not to use the extensions).<br style="font-size: 2">>><br style="font-size: 2">>> My thoughts/observations anyway, but I'm not the one paying so...<br style="font-size: 2">>> :-)<br style="font-size: 2">>> Jonathan<br style="font-size: 2">>><br style="font-size: 2">>> From: Andreas Neumann<br style="font-size: 2">>> To: qgis-user , qgis-developer<br style="font-size: 2">>> Date: 30/03/2012 08:26<br style="font-size: 2">>> Subject: [Qgis-user] Oracle Spatial Driver<br style="font-size: 2">>> Sent by: qgis-user-bounces@lists.osgeo.org [4]<br style="font-size: 2">>><br style="font-size: 2">>> -------------------------<br style="font-size: 2">>><br style="font-size: 2">>> Hi,<br style="font-size: 2">>><br style="font-size: 2">>> The City of Dornbirn and the Province of Vorarlberg have an<br style="font-size: 2">>> interest in<br style="font-size: 2">>> getting an Oracle Spatial native driver developed for QGIS. They<br style="font-size: 2">>> would<br style="font-size: 2">>> finance the bulk of the development, but they are interested in<br style="font-size: 2">>> other<br style="font-size: 2">>> financial contributions if there are other interested commercial or<br style="font-size: 2">>><br style="font-size: 2">>> governmental QGIS users with an interest in the access of Oracle<br style="font-size: 2">>> databases.<br style="font-size: 2">>><br style="font-size: 2">>> Please contact me if you have an interest in helping this project<br style="font-size: 2">>> financially. We are not interested in small donations but in more<br style="font-size: 2">>> substantial amounts in order not to complicate the billing process<br style="font-size: 2">>> too<br style="font-size: 2">>> much.<br style="font-size: 2">>><br style="font-size: 2">>> Thanks,<br style="font-size: 2">>> Andreas<br style="font-size: 2">>><br style="font-size: 2">>> --<br style="font-size: 2">>> --<br style="font-size: 2">>> Andreas Neumann<br style="font-size: 2">>> Böschacherstrasse 10A<br style="font-size: 2">>> 8624 Grüt (Gossau ZH)<br style="font-size: 2">>> Switzerland<br style="font-size: 2">>> _______________________________________________<br style="font-size: 2">>> Qgis-user mailing list<br style="font-size: 2">>> Qgis-user@lists.osgeo.org [5]<br style="font-size: 2">>> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>[6]<br style="font-size: 2">>><br style="font-size: 2">>> This transmission is intended for the named addressee(s) only and<br style="font-size: 2">>> may contain sensitive or protectively marked material up to<br style="font-size: 2">>> RESTRICTED and should be handled accordingly. Unless you are the<br style="font-size: 2">>> named addressee (or authorised to receive it for the addressee) you<br style="font-size: 2">>> may not copy or use it, or disclose it to anyone else. If you have<br style="font-size: 2">>> received this transmission in error please notify the sender<br style="font-size: 2">>> immediately. All email traffic sent to or from us, including without<br style="font-size: 2">>> limitation all GCSX traffic, may be subject to recording and/or<br style="font-size: 2">>> monitoring in accordance with relevant legislation.<br style="font-size: 2">>><br style="font-size: 2">>> _______________________________________________<br style="font-size: 2">>> Qgis-user mailing list<br style="font-size: 2">>> Qgis-user@lists.osgeo.org [7]<br style="font-size: 2">>> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>[8]<br style="font-size: 2">><br style="font-size: 2">><br style="font-size: 2">><br style="font-size: 2">> Links:<br style="font-size: 2">> ------<br style="font-size: 2">> [1] <a href="mailto:a.neumann@carto.net">mailto:a.neumann@carto.net</a><br style="font-size: 2">> [2] <a href="mailto:qgis-user@lists.osgeo.org">mailto:qgis-user@lists.osgeo.org</a><br style="font-size: 2">> [3] <a href="mailto:qgis-developer@lists.osgeo.org">mailto:qgis-developer@lists.osgeo.org</a><br style="font-size: 2">> [4] <a href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a><br style="font-size: 2">> [5] <a href="mailto:Qgis-user@lists.osgeo.org">mailto:Qgis-user@lists.osgeo.org</a><br style="font-size: 2">> [6] <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br style="font-size: 2">> [7] <a href="mailto:Qgis-user@lists.osgeo.org">mailto:Qgis-user@lists.osgeo.org</a><br style="font-size: 2">> [8] <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br style="font-size: 2">> [9] <a href="mailto:jonathanmoules@warwickshire.gov.uk">mailto:jonathanmoules@warwickshire.gov.uk</a><br style="font-size: 2"><br style="font-size: 2">--<br style="font-size: 2">--<br style="font-size: 2">Andreas Neumann<br style="font-size: 2">Böschacherstrasse 10A<br style="font-size: 2">8624 Grüt (Gossau ZH)<br style="font-size: 2">Switzerland<br style="font-size: 2"></font></tt><br><br><br>This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.<br>
</p>
</div>
</td>
</tr>
</table>
</body>
</html>