I am developing custom geoprocessing tool (class-library project) on ArcGIS 10.2. This project uses Oracle.DatAccess from C:\Oracle\product\10.2.0\client_32\ODP.NET\bin\1.x . This is a simple tool which queries oracle 10g database and returns a distinct records from a table. This tool is working fine from tool box but when this tool is published in REST, it throws Oracle type initialize exception on line
Connection = new OracleConnection(constr);
ArcGIS server 10.2, Visual Studio 2012.
Server: Windows 2012 64bit OS
Oracle client : installed both oracle 32 and oracle 64bit (C:\oracle\product\10.2.0\Client_32, C:\oracle\product\10.2.0\Client_64)
In case you wish to try the Oracle Instant Client, instead of Oracle Client, to which Vince referred in the other thread, Richard Watson provided some install instructions in this post:
Can you explain difference between Oracle instant client and regular oracle client software which comes with Oracle installer?. As said, I have installed oracle client (64 and 32bit) and set a PATH variable as ESRI specified. Still am struggling to get the result.
