ORA-01036: illegal variable name/number
-
Hi, I've tried a simple app with a gridview, sqldatasource connected to Oracle. On the Update COmmand i've wrote a simple query :UPDATE X SET field=77. In SQLBUilder when i execute it it works just fine but from app i get this "ORA-01036: illegal variable name/number" Can anyone help please ? thanks!
-
Hi, I've tried a simple app with a gridview, sqldatasource connected to Oracle. On the Update COmmand i've wrote a simple query :UPDATE X SET field=77. In SQLBUilder when i execute it it works just fine but from app i get this "ORA-01036: illegal variable name/number" Can anyone help please ? thanks!
you write query like:" UPDATE X SET field=77" so as per your query, Table Name : X Field Name : field so u must understand that "field" must be field name of table X. and datatype with any numeric. try this. Dipan Patel.
-
you write query like:" UPDATE X SET field=77" so as per your query, Table Name : X Field Name : field so u must understand that "field" must be field name of table X. and datatype with any numeric. try this. Dipan Patel.
Hi and thanks you for your reply, yes i understand.. the exact SQL is : "UpdateCommand="UPDATE TABLOU SET STADIU=77" the field called STADIU is type number. I've tried also with integer but i get the same error -- modified at 17:40 Saturday 6th May, 2006