从光标获取数据时SQl错误-1007 [英] SQl error -1007 while fetching data from cursor

问题描述

当我从光标中获取数据到C程序中的结构时，我得到SQl错误-1007。



有人可以建议可能出现什么问题，我关于这个错误在NET上找不到多少。



提前感谢

I am getting SQl error -1007 when i am fetching data from cursor into a structure in C program .

Can someone suggest what can be the issue, I do not find much on NET about this error.

thanks in advance

推荐答案

< b> Oracle数据库错误代码ORA-01007 - 变量不在选择列表中Oracle数据库错误代码ORA-1007描述：变量不在选择列表中



错误原因： 引用了SELECT子句中未列出的变量。如果为position参数传递的数字小于1或更大，则会发生这种情况以下任何调用中SELECT子句中的变量数：DESCRIBE，NAME或DEFINE。在SQL * Forms或SQL * Report中，在INTO子句中指定比SELECT子句中更多的变量也会导致此错误。





如何解决： 确定列出的问题导致问题并采取相应措施。

Oracle database error code ORA-01007 – variable not in select listOracle Database Error Code ORA-1007 Description:variable not in select list

Error Cause: A reference was made to a variable not listed in the SELECT clause.This can occur if the number passed for the position parameter is less than one or greater than the number of variables in the SELECT clause in any of the following calls: DESCRIBE, NAME, or DEFINE. In SQL*Forms or SQL*Report, specifying more variables in an INTO clause than in the SELECT clause also causes this error.


How to Solve : Determine which of the problems listed caused the problem and take appropriate action.

这篇关于从光标获取数据时SQl错误-1007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！