Database Utilities (MOSC)

MOSC Banner

COMMIT error in trigger

edited Jan 13, 2011 11:32AM in Database Utilities (MOSC) 1 commentAnswered

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 (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center