What does the following Oracle error mean: invalid column index

Question

I am getting the following error while testing some code:

SQLException: Invalid column index

What exactly does this mean?

Is there any online documentation describing what are all the oracle error codes and statements?

Answer 1

If it is an SQLException which is thrown by Java, then it is most possibly because you're attempting to set or get the value from the ResultSet, although, the index you are utilising is not within the range.

For example, you might be attempting to get the column at index 3 from the result set, although you are simply having two columns being returned from the SQL query.

Join the SQL Training course now if you want to gain more knowledge in SQL.