Cause: In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query.Action: Terminate processing for the SELECT statement.
sqlcode 的取值范围如下所示: 值为0 时,表示成功。 值<0 时,表示语句在数据库中执行失败,其具体错误码可能和 Oracle 有差别,在应用程序中希望直接进行 sqlca.sqlcode<0 的判断。 值>0 时,表示在数据库中未找到合适的数据,目前大于 0 的值只支持 1403,对应信息 DATA NOT FOUND。 sqlerrm 结构体包括两个成员...
(1)、select into 数组的时候, 当记录数<数组长度时,sqlcode返回1403 当记录数=数组长度时,sqlcode返回0 当记录数>数组长度时,sqlcode返回-2112(返回太多行) (3)、select into 数组时 首先判断sqlca.sqlerrd[2] > 0 成功 另外判断 sqlca.sqlcode=-2112为数组越界 然后判断 sqlca.sqlcode<0 为失败 select into...
Members of the SQLCA structure The SQLCA structure comprises several members, includingsqlcode,sqlerrm, andsqlerrd. Values and descriptions ofsqlcode: The value 0 indicates statement execution success. When the value is less than 0, the statement failed to be executed in OceanBase Database. The spec...