COMMIT error in trigger
Can a trigger not create a job with "dbms_scheduler" ??
I get the following error:
ORA-04092: cannot in a trigger
ORA-06512: at "BT.APP_SCHJOB_TRG", line 46
ORA-04088: error during execution of trigger 'BT.APP_SCHJOB_TRG'
where:
----------------------------------------------------------
CREATE OR REPLACE TRIGGER APP_SCHJOB_TRG
AFTER INSERT
ON APPL_PROC REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
ONBS_START TIMESTAMP;
TMP VARCHAR2(100);
onbs_program_name VARCHAR2(100);
BEGIN
TMP := OB_UTIL.GET_REP_INTV(:NEW.APP_EX_SEQ);
ONBS_START := SYSTIMESTAMP + TO_DSINTERVAL('0 00:00:10');
onbs_program_name := :NEW.APP_JOB_NAME;
DBMS_SCHEDULER.CREATE_JOB (