Oracle触发器提交并发请求

it2024-02-01  79

CREATE OR REPLACE TRIGGER bitc_wip_outsidejob_create_trg AFTER UPDATE ON bitc_bom_entity_workbench FOR EACH ROW WHEN (1 = 1) DECLARE l_req_id NUMBER; PRAGMA AUTONOMOUS_TRANSACTION; --自治事务 BEGIN fnd_global.apps_initialize(user_id => fnd_global.user_id, resp_id => fnd_global.resp_id, resp_appl_id => fnd_global.resp_appl_id); l_req_id := fnd_request.submit_request(application => 'BITC', program => 'BITC_HQC_TEST', description => '', start_time => '', sub_request => FALSE); COMMIT; END bitc_wip_outsidejob_create_trg;
最新回复(0)