ORA-01036 illegal variable name/number

[nmertens]

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.

[Shalex]

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.