Problem writing to SDE using ArcObjects API -Error- ORA-01036: illegal variable name

FarooqMunir — Fri, 30 Apr 2010 16:09:30 GMT

Hi,

We have custom-built web application in .NET that we use to manage Offshore surveys and data. The application is written in VB.NET and utilises ArcObjects core library, included with ArcGIS server 9.2 to handle geographical operations for storing and retrieving data from an SDE database, while the ArcGIS server 9.2 WebADF is used for drawing a Map and handling functionality within the Map.

The application was originally written with ArcSDE 9.0, but after migration to 9.2 we are unable to write any data to SDE using ArcObjects API. Although that may not be the real cause of the problem. Application returns the following error:

>System.Runtime.InteropServices.COMException :{"Underlying DBMS error[ORA-01036: illegal variable name/number
][SEAL.SURVEY_CENTRE]"}
>ErrorCode: -2147216072
>Helplink : esri_csGeoDatabase.hlp
>Source : esriDataSourcesGDB.SdeWorkspace.1
>StackTrace: at ESRI.ArcGIS.Geodatabase.IWorkspaceEdit.StopEditOperation()
at Nam.Components.Common.DataAccess.DataBase.StopEditing(Boolean SaveEdits) in E:\Users\GIM\Farooq\SEAL\CommonUtils\DataAccess\DataBase.vb:line 96

Currently we have the following setup in the organisation:

Oracle 9.2.0
ArcSDE 9.2
ArcGIS server for .NET 9.2 SP3
ArcGIS server Web ADF Runtime 9.2 SP4
ArcIMS 9.2 SP4

I can provide more information and appreciate any help.

Regards,

Farooq

topic Problem writing to SDE using ArcObjects API -Error- ORA-01036: illegal variable name in ArcObjects SDK Questions

Problem writing to SDE using ArcObjects API -Error- ORA-01036: illegal variable name