This being the ONLY place that helped me solve my ORA-01036 error (which, for anyone else who is still having trouble, was solved using semma's method as described below:
semma
I have noticed that when I have a gridview and when I get the ora-1036 error, I have found that if I change the "bind" to "eval" in template fields, on columns that are not included in my update command, that my updates then work.
However, I have now run into a new problem. The data gets updated to the appropriate row... but it is not reflected when I call upon that record again. As in, I updated a field called "FUNCTION" with a value of "This is a test." I even accessed the site
from a different computer, and the "FUNCTION" field was blank. To investigate further, I logged on to the remote server and SQL Plussed my way into that record, and found that the value of FUNCTION was "This is a test." So, the data is updating, but not showing.
Has this happened to anyone else?
bwagne19
Member
145 Points
33 Posts
Re: 1036 (ORA-01036: illegal variable name/number)
May 18, 2006 12:54 PM|LINK
This being the ONLY place that helped me solve my ORA-01036 error (which, for anyone else who is still having trouble, was solved using semma's method as described below:
However, I have now run into a new problem. The data gets updated to the appropriate row... but it is not reflected when I call upon that record again. As in, I updated a field called "FUNCTION" with a value of "This is a test." I even accessed the site from a different computer, and the "FUNCTION" field was blank. To investigate further, I logged on to the remote server and SQL Plussed my way into that record, and found that the value of FUNCTION was "This is a test." So, the data is updating, but not showing. Has this happened to anyone else?
-Brian