1.Oracle行锁定,具体存储过程实现如下:
CREATE OR REPLACE PROCEDURE TASK_P(TASKID IN VARCHAR2,
UPDATE_COUNT OUT NUMBER) IS
STR_SQL VARCHAR2(2000);
BEGIN
UPDATE_COUNT := 0;
STR_SQL := ' SELECT T.* FROM TASKS_T T ' ||
' WHERE T.TASK_ID = ' || TASKID || ' FOR UPDATE NOWAIT ';
EXECUTE IMMEDIATE STR_SQL;
UPDATE_COUNT := SQL%ROWCOUNT;
EXCEPTION
WHEN OTHERS THEN
UPDATE_COUNT := -1;
END TASK_P;
2.在java中调用方式为(Ibatis调用):
call TASK_P(?,?)
初学者,如用的不好,多多指教!谢谢