This discussion is archived
1 Reply Latest reply: Dec 28, 2012 4:43 PM by Simon Greener RSS

Difficulty with ST_GEOMETRY.

893152 Newbie
Currently Being Moderated
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.
  • 1. Re: Difficulty with ST_GEOMETRY.
    Simon Greener Journeyer
    Currently Being Moderated
    Milton,

    Your problems relate to something that is not an Oracle product.

    This forum is about Oracle's spatial offerings not ESRI's.

    You should direct your question to the appropriate ESRI forum (or start using the better product with ESRI software - which it can do!).

    regards
    Simon

    Edited by: Simon Greener on Dec 29, 2012 11:43 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points