0 Replies Latest reply: Dec 20, 2012 12:42 PM by 893152 RSS

    Difficulty with ST_GEOMETRY.

    893152
      Hello all,

      I am having difficulty getting oracle.DataAccess.dll to read the schema of an ArcSDE ST_GEOMETRY column.

      We are using Oracle 11.2.0.1 x64bit running on Microsoft 2008 R2 x64bit enterprise server. Have installed ArcSDE 10.0 sp2 x64bit and configured to work apprpriately with Oracle. I can use sqlPlus to issue a query against a table with an ST_GEOMETRY column and use a method from the st_shapelib.dll with success, but..

      When I try to access the same data from our webservice using the oracle.DataAccess.dll I get the following error from SDE(?)..

      Exception: Custom type mapping for 'dataSource='SDEGOMU-ORA-TEST-01' schemaName='SDE' typeName='ST_GEOMETRY'' is not specified or is invalid.

      In the Web.config file I have the following:

      <oracle.dataaccess.client>
      <settings>
      <add name="ST_GEOMETRY" value="udtMapping factoryName='st_shapelib.dll' typeName='ST_GEOMETRY' schemaName='SDE'/>
      schemaName='SDE'"/>
      </settings>
      </oracle.dataaccess.client>

      I am using oracle.DataAccess.dll version 2.112.1.0.

      Has anyone else encountered this problem and have a solution. It is vexing me.

      Thank you,

      Milton S.