java.sql.SQLException: Invalid column index

[Former Member]

Hello Experts,

I am developing one application on web dynpro java, here the users will enter data and the data will be stored in Oracle database, while saving the form i am having this exception:

java.sql.SQLException: Invalid column index

please help me out with this error

[Former Member]

Hi Orkun,

I have checke the sql statement, its ok in the values, when I am deploying the application, i am getting this error. I am not getting problem is where; is it in my database or in code:

java.sql.SQLException: Invalid column index

[Former Member]

Hi Shilpi

Can you execute the code directly in your database .. from SQLPLUS ? If it works , the the issue is in the calling code..

Please check this - Oracle/PLSQL: ORA-00913 Error

Thanks

Rishi