Solved! Go to Solution.
Regarding the Oracle bug, it actually looks like Oracle has not adequately updated their bug database. Upon further investigation on our bug (NIM069549) that references the Oracle bug, there is an activity logged by one of the Esri Inc support staff. He mentions that he spoke to Oracle in May 2012, and that Oracle has actually closed this Oracle incident (12537431) as NOT a bug. This analyst says that the reason given is because OCIEnvNlsCreate uses the national language setting of the computer (Nls = National Language Setting). OCIEnvNlsCreate is used when creating an sdo_georaster and the failure occurs when the Oracle xml document is created.
Basically ??? the reason that users can experience this Oracle bug is because of regional language settings in either the O/S or Oracle.
We have spoken to Esri Inc and have requested that the following be updated to reflect this finding from Oracle:
NIM069549 -
http://support.esri.com/en/bugs/nimbus/TklNMDY5NTQ5
NOTE: have requested that the alternate solution be changed to state that it can be caused by regional language settings. Also, reason for rejection needs to be changed accordingly
Error: An Oracle LPX-0019 error occurs when inserting data into an SDO_GEORASTER field -http://support.esri.com/en/knowledgebase/techarticles/detail/38940
NOTE: have requested that the solution/workaround be changed to state that it can be caused by regional language settings. Suggested to try changing to English language setting.
ArcGIS and the Oracle Spatial raster type - http://resources.arcgis.com/en/help/main/10.1/index.html#//002n0000006z000000
NOTE: this is the article with the known limitations at the bottom.
Since metadata is in XML format, it is quite possible that the commas you were getting with the French language setting were directly related to this issue. The Oracle XmlLoadDom function returns the erorr, so you will see this error in Oracle, not in ArcMap.
A simple copy/paste of a raster stored as a BLOB into an SDO_GeoRaster type make ArcCatalogue to freeze indefinitely (more than 1h) doing nothing. No error message.
The copy and paste is probably mostly a server task.
XmlLoadDom fails to parse and load an XML document when the OCI session is
created with
OCIEnvNlsCreate function. But the same works fine when session is created
with OCIEnvCreate function.
Unfortunatly, to copy/paste a raster within the same Database ArcCatalog needs to read the file through the network on the client machine and send it back to the server. I agree that it would be much faster if ArcCatalog could acheive the same task only on the server.
Even better, it would be nice if ESRI could release an SQL API to manage spatial features from the RDBMS. But I'm going away from the question here...
ESRI more or less already did that, see the following links:
ArcSDE SDK 10 C and Java API
and
ArcGIS Spatial Data Server REST API
The tests are made using the Direct Connect with Oracle 11g client installed on the client computer.
Those API are great at what they do, but as for using them to manage data in a RDBMS sounds like taking an airplane when you can actually bike to work 😉
Don't know if it is in anyway related nor of any help, but I saw this old thread on an OTN forum related to the same "OCIEnvNlsCreate" function and issues with it in PHP:
https://forums.oracle.com/forums/thread.jspa?threadID=486961