ORA-01036 illegal variable name/number

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
nmertens
Posts: 2
Joined: Tue 18 Aug 2009 06:55

ORA-01036 illegal variable name/number

Post by nmertens » Tue 18 Aug 2009 09:19

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 20 Aug 2009 11:41

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.

Post Reply