Code Project

Link Unit

Tuesday, December 18, 2007

Update on gridview produces ORA-01036: illegal variable name/number

While using SQLdatasource to access and update an Oracle table using UpdateCommand , error ORA-01036 occurs if we by mistake use @ in parameter name ,some missing parameter or missing providername.

Solution :

  1. For update statement to work in case of Oracle all the parameters must be there and in exact order.
  2. ProviderName = "System.Data.OracleClient" in SQLDataSource
  3. : is to be used in place of @

I hope it help fellow programmers .

Post a Comment