ORA-01036; illegal variable name/number
If you also have visual studio and you are using the details view. I suggest reconfiguring your data source. I was receiving the ORA-01036 error, and all I had to do was just reconfigure my SQL source, and it generated it properly for me. For me it was that I was not handling the original values properly when I was trying to update my data source.
I was also in Oracle.