以下Oracle错误意味着什么：无效的列索引 [英] What does the following Oracle error mean: invalid column index

问题描述

我在测试一些代码时遇到以下错误：

I got the following error while testing some code:

SQLException：列索引无效

SQLException: Invalid column index

究竟是什么意思？

是否有在线文档解释所有Oracle错误代码和语句？

Is there an online document explaining what all the Oracle error codes and statements?

推荐答案

如果这是Java抛出的SQLException，则很可能是因为您尝试从ResultSet获取或设置值，但您使用的索引不在该范围内。

If that's a SQLException thrown by Java, it's most likely because you are trying to get or set a value from a ResultSet, but the index you are using isn't within the range.

例如，您可能尝试从结果集中获取索引3处的列，但是您只从SQL查询中返回了两列。

For example, you might be trying to get the column at index 3 from the result set, but you only have two columns being returned from the SQL query.

这篇关于以下Oracle错误意味着什么：无效的列索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！