I apologise if this is posted before or a really obvious answer - but I'm having trouble connecting to our Oracle server using the 'Oracle Spatial' connector in MapInfo.
We can connect using ODBC (which doesn’t support geometry), and but we hit an error when using the ‘Oracle Spatial’ connector. The Error is "OCI-21560: argument 4 is null, invalid, or out of range". This is a weird error as there's only 3 arguments to pass the driver.
MapInfo Support are telling us that we need to have the Oracle Spatial extension installed on the server to use the ‘Oracle Spatial’ driver, but I’m a little surprised about this as Oracle supports geometry natively without the Spatial extension.
Does anyone have experiences where they have used Geometry in Oracle with MapInfo, without purchasing the Spatial extension? Or I am I just barking up the wrong tree (and have to bite the bullet and purchase the fairly expensive Spatial Extension)? I know I should just believe PB Insight support, but I’m (foolishly) optimistic…
From a very hopeful,
Peadar O’Connor
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
RichI do not think you are "barking up the wrong tree". It's been too many years ago for me to be 100% certain, but I believe I was able to connect MapInfo to Oracle Locator. "Locator" is, or at least was, the name of Oracle's free, stripped down version of the Spatial extension. I was testing interoperability between several GIS platforms at the time which is why I'm not entirely certain of my recollection. I think Locator is just Spatial w/o some analytical functions, but the interface and storage formats are the same.
Of course my standard advice is to ditch Oracle and switch to PostgreSQL & PostGIS.
Good luck, keep us posted.
On Mon, Jan 6, 2014 at 4:47 PM, Peadar <wherei...@gmail.com> wrote:
Hi All,
I apologise if this is posted before or a really obvious answer - but I'm having trouble connecting to our Oracle server using the 'Oracle Spatial' connector in MapInfo.��
We can connect using ODBC (which doesn�t support geometry), and but we hit an error when using the �Oracle Spatial� connector. �The Error is "OCI-21560: argument 4 is null, invalid, or out of range". This is a weird error as there's only 3 arguments to pass the driver.
MapInfo Support are telling us that we need to have the Oracle Spatial extension installed on the server to use the �Oracle Spatial� driver, but I�m a little surprised about this as Oracle supports geometry natively without the Spatial extension.
Does anyone have experiences where they have used Geometry in Oracle with MapInfo, without purchasing the Spatial extension? Or I am I just barking up the wrong tree (and have to bite the bullet and purchase the fairly expensive Spatial Extension)?� I know I should just believe PB Insight support, but I�m (foolishly) optimistic�
From a very hopeful,
Peadar O�Connor�
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
�
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
�
Hi Richard,Thank you for your reply!We've set up a Oracle XE database on a local PC (the free 10gig database), which naturally does not have the Spatial extension, and I was able to connect to the database using 'Oracle Spatial' connector - which reveals two things:
1. The Oracle Database does NOT need the Spatial extension; and2. The issue does appear to be a server configuration issue.
What that issue is, I'm not sure yet, but the proof of concept shows we're not getting the whole story from the PB Insight support team. �They're not able to say why the driver has an Argument 4 error when there's only 3 arguments to pass, so we're not sure what the conflict is yet.
I'll post back here if we figure out what the configuration issue is with the proper server.
BTW yes, I started mucking around with Postgre/PostGIS but it's not permitted by our IT Team, so we had to drop that. Life might have been so much easier! :)
Thanks again.
Peadar.
On Tuesday, January 7, 2014 9:47:49 AM UTC+10, Peadar wrote:
Hi All,
I apologise if this is posted before or a really obvious answer - but I'm having trouble connecting to our Oracle server using the 'Oracle Spatial' connector in MapInfo.��
We can connect using ODBC (which doesn�t support geometry), and but we hit an error when using the �Oracle Spatial� connector. �The Error is "OCI-21560: argument 4 is null, invalid, or out of range". This is a weird error as there's only 3 arguments to pass the driver.
MapInfo Support are telling us that we need to have the Oracle Spatial extension installed on the server to use the �Oracle Spatial� driver, but I�m a little surprised about this as Oracle supports geometry natively without the Spatial extension.
Does anyone have experiences where they have used Geometry in Oracle with MapInfo, without purchasing the Spatial extension? Or I am I just barking up the wrong tree (and have to bite the bullet and purchase the fairly expensive Spatial Extension)?� I know I should just believe PB Insight support, but I�m (foolishly) optimistic�
From a very hopeful,
Peadar O�Connor�