17,086
社区成员
发帖
与我相关
我的任务
分享
DECLARE
TYPE tmp IS TABLE OF hs_user.users%ROWTYPE;
tmpdata tmp;
v_cursor hstype.t_cursor;
BEGIN
OPEN v_cursor FOR SELECT * FROM hs_user.users WHERE ROWNUM<5;
CLOSE v_cursor;
IF v_cursor%NOTFOUND
THEN
DBMS_OUTPUT.put_line('t_curosr not found');
ELSE
DBMS_OUTPUT.put_line('found');
END IF;
SELECT a.* BULK COLLECT INTO tmpdata FROM hs_user.users a WHERE ROWNUM<6;
IF SQL%NOTFOUND
THEN
DBMS_OUTPUT.put_line('abccccc');
ELSE
DBMS_OUTPUT.put_line('else');
END IF;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line('exception');
--CLOSE v_cursor; 应该放这里
END;