Sunday, 22 January 2017

Oracle error &ERRNO: &REASON has been detected in &ROUTINE.

Error:


Oracle error &ERRNO: &REASON has been detected in &ROUTINE.

Solution:

  1. select trigger_name,status from dba_triggers where trigger_name like ‘ALR_FND%UAR%';
  2. Disable the trigger ‘ALR_FND_USER_UAR’ using sqlplus 
           SQL> alter trigger ALR_FND_USER_UAR disable;

No comments:

Post a Comment