Chinaunix

标题: select .. for update nowait 异常处理 [打印本页]

作者: bealla 时间: 2011-12-21 08:44
标题: select .. for update nowait 异常处理

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;

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)