Thanks guys!
I checked the log, iam getting this error when all the columns have values ie no '' for any column. one more thing i forgot to mention is this error occurs when i run first time, but when i run second time, This record updated without any issues. weird huh!
I will try incremental...
Thanks for the reply.
This is my Query:
cmd CommandText = UPDATE TEST.DETAILS SET TEST_APP = 'Y', INSURANCE = 'Y', SECURITY = 'Y', CONTACT = '' WHERE ID = 7865
When i run this query in Sql plus or Toad, i have no problems. The row gets updated.I see this error only when iam running it thru c#...
Iam running Oracle query in .NET 2005, using C#. Iam getting error for a simple update statement. details are as follows:
Message: ORA-01036: illegal variable name/number
Source: System.Data.OracleClient
at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.