Oracle Trigger Problem - ORA-06519

I write this trigger and I compile it without errors

DECLARE
tmpVar NUMBER;
pragma AUTONOMOUS_TRANSACTION;
/******************************************************************************
   NAME:       
   PURPOSE:    

   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        17/03/2012             1. Created this trigger.

   NOTES:

   Automatically available Auto Replace Keywords:
      Object Name:     
      Sysdate:         17/03/2012
      Date and Time:   17/03/2012, 11:24:45 Õ, and 17/03/2012 11:24:45 Õ
      Username:         (set in TOAD Options, Proc Templates)
      Table Name:       (set in the "New PL/SQL Object" dialog)
      Trigger Options:  (set in the "New PL/SQL Object" dialog)
******************************************************************************/
BEGIN
   tmpVar := 0;
   
   execute immediate 'insert into tbl_testxx select * from tbl_EmpMONTHSALARY';
	/*IF :NEW.emp_id = 30 THEN*/
		/*update TBL_EmpTest
		set fld_EmpId = :NEW.emp_id
		where fld_EmpId not in (:NEW.emp_id);*/
		
		/*INSERT INTO tbl_EmpTest
		FLD_EMPID
		VALUES
		(:NEW.emp_id);*/
	/*END IF;*/			    
END ;

Open in new window


I get this error
ORA-06519
ORA-06512
ORA-04088

Open in new window

egovernmentAsked:
Who is Participating?
 
flow01Connect With a Mentor Commented:
beside answering johnsone's post

try coding an  


exception when others then
    rollback;  -- before leaving an AUTONOMOUS_TRANSACTION
                   --  a COMMIT or ROLLBACK should occur
    raise;  -- there was a failure  so reraise
end;

-- to loose the ORA-06519
0
 
johnsoneSenior Oracle DBACommented:
You are going to need to post the entire trigger definition.

My guess is that the trigger is causing itself to fire again?  Not sure without the full trigger definition.
0
All Courses

From novice to tech pro — start learning today.