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
