Hi folks!
I have to insert new rows with a ASPxGridView (DevExpress) and get the ORA-01036 error.
-DB connection: TNS-NAMES v.11 client or direct (always the same).
-Table EMP from SCOTT
-INSERT command: INSERT INTO SCOTT.EMP (ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES (:ENAME, :JOB, :MGR, :HIREDATE, :SAL, :COMM, :DEPTNO)
-Parameters are generated.
ASP-Code:
3
Please, what can I do?
N.M.
ORA-01036 illegal variable name/number
1. Please change the ReadOnly property for the EMPNO field of your ASPxGridView to False:
2. The Insert command of OracleDataSource should be the following:
INSERT INTO SCOTT.EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES (:EMPNO, :ENAME, :JOB, :MGR, :HIREDATE, :SAL, :COMM, :DEPTNO)
3. Please don't forget to add the EMPNO parameter to the collection of InsertParameters:
Please notify us about the results.
2. The Insert command of OracleDataSource should be the following:
INSERT INTO SCOTT.EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES (:EMPNO, :ENAME, :JOB, :MGR, :HIREDATE, :SAL, :COMM, :DEPTNO)
3. Please don't forget to add the EMPNO parameter to the collection of InsertParameters:
Please notify us about the results.