ORA-01036 illegal variable name/number
Posted: Mon 23 Mar 2009 10:44
Hello, I recieve this exception when i try to update a row with a formview control. The oracle column E_PD_SURNAME is char(20). I use an oracle 10g database and vs2008 3.5 framework and oracle provider Version=5.0.22.0
Exception
.ASPX Code
Exception
Code: Select all
Devart.Data.Oracle.OracleException was unhandled by user code
Code=1036
ErrorCode=-2147467259
Message="ORA-01036 illegal variable name/number"
Offset=0
Source="Devart.Data.Oracle"
StackTrace:
en Devart.Data.Oracle.s.a(aq[] A_0, Byte[] A_1)
en Devart.Data.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
en Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
en Devart.Data.Oracle.Web.OracleDataSource.a.a(CommandBehavior A_0)
en System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
en Devart.Data.Oracle.OracleCommand.ExecuteReader(CommandBehavior behavior)
en Devart.Data.Oracle.Web.OracleDataSource.a.a(CommandBehavior A_0)
en System.Data.Common.DbCommand.ExecuteReader()
en Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
en System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation)
en System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues)
en System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback)
en System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation)
en System.Web.UI.WebControls.FormView.UpdateItem(Boolean causesValidation)
en _Default.Button2_Click(Object sender, EventArgs e) en E:\ceinsaDE\ASP.NET\GDCEcinfa\Default.aspx.vb:lĂnea 13
en System.Web.UI.WebControls.Button.OnClick(EventArgs e)
en System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
en System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
en System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
en System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:
.ASPX Code
Code: Select all
'>