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 · Accepted solution]

Hi Shilpi,

>> java.sql.SQLException: Invalid column index

Check the SQL statement and parameters that you are supplied in the code. This error mostly caused by providing wrong parameters on the code.

Remove set parameters first then execute the code. Then add the removed parameters one by one and find the root cause.

Best regards,

Orkun Gedik