ORACLE 锁定事物

 PROCEDURE p_lock_Job_Status (vr_job OUT ae_job%ROWTYPE, vn_job_id varchar2, vb_waiting BOOLEAN)
    AS
    BEGIN
        IF vb_waiting
        THEN
            SELECT *
              INTO vr_job
              FROM ae_job
             WHERE job_id = vn_job_id
            FOR UPDATE;
        ELSE
                SELECT *
                  INTO vr_job
                  FROM ae_job
                 WHERE job_id = vn_job_id
            FOR UPDATE NOWAIT;
        END IF;
    EXCEPTION
        WHEN OTHERS
        THEN
            raise_application_error (-20001, '不能锁定配仓');
    END;