Select/update table where trigger against, ORA-04091 error occurs
CREATE OR REPLACE
TRIGGER udpate_sheet_processing
AFTER INSERT ON sheet_item
FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION; -- 自治事務
v_sheet_id VARCHAR2(50);
v_processing_entry NUMBER(5);
CURSOR get_processing_amount IS
SELECT count(*)+1
FROM sheet_item
WHERE sheet_id = v_sheet_id
;
BEGIN
v_sheet_id := :NEW.sheet_id;
OPEN get_processing_amount;
FETCH get_processing_amount INTO v_processing_entry;
CLOSE get_processing_amount;
UPDATE product_checksheet
SET sheet_processing_entry = v_processing_entry
WHERE sheet_id = v_sheet_id;
COMMIT; -- commit for update
END;