我声明了一个游标,该游标不会从表中提取任何数据,因为根据我的where子句,薪水不会超过60000。光标应该是空的吗?我尝试了两种方法来获取错误信息,但我得到了类似“匿名块已完成”的信息。
set serverout ON
declare
c_empid kt_test.empid%type;
cursor c_kt is select empid into c_empid from kt_test where salary > 60000;
BEGIN
open c_kt;
fetch c_kt into c_empid;
exception
WHEN NO_DATA_FOUND THEN
raise_application_error(-20001,'Data not found for employee');
close c_kt;
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20002,'Other error-'||SQLCODE||'-'||SQLERRM);
end;和
set serverout ON
declare
c_empid kt_test.empid%type;
cursor c_kt is select empid into c_empid from kt_test where salary > 60000;
BEGIN
open c_kt;
fetch c_kt into c_empid;
IF c_kt%NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE('Explicit Cursor: No data found');
END IF;
END;
line 1: SQLPLUS Command Skipped: set serverout ON
anonymous block completed为了得到错误消息,这里缺少了什么?
https://stackoverflow.com/questions/51305202
复制相似问题