andes0 发表于 2012-03-07 11:58

update sqlcode=1403 问题

proc里一个update语句update a
                                 set b=2
                                 where 1=2

现在的执行结果是SQLCODE = 1403

记得update未找到记录SQLCODE是返回0的，需要检查sqlca.sqlerrd的返回判断更新是否成功

请教到底是1403还是0,跟编译选项有无关系,谢谢!


doni 发表于 2012-03-07 15:16

sqlca.sqlerrd是记录笔数。
sqlcode = 1403 --> no row.

moon38sun 发表于 2012-03-08 14:18

ORA-01403 no data found

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.
页: [1]
查看完整版本: update sqlcode=1403 问题