CREATE OR REPLACE PROCEDURE pd_testnowait IS
l_name VARCHAR2(50);
result_ varchar2(500);
BEGIN
SELECT v_name
INTO l_name
FROM test1
WHERE v_id = '3'
FOR UPDATE NOWAIT;
EXCEPTION
WHEN OTHERS THEN
IF (SQLCODE = -54)
THEN
result_ :='ERR111';
return;
end if;
IF (SQLCODE = -60)
THEN
result_ :='ERR112';
return;
END IF;
result_ :='ERR999';
END pd_testnowait;
阅读(1698) | 评论(0) | 转发(0) |