Trigger underlying code no longer works correctly. Stored Proc / DBMS_JOB.Submit
We are past a Windows 19c DB upgrade and some functionality seems to have changed in our environment. Currently have a trigger that was executing a procedure in a package:
Before Update
IF UPDATING
THEN
IF :old.acct_disabled_indc <> :new.acct_disabled_indc
THEN
IF (:new.acct_disabled_indc = 'Y')
THEN
l_action := 'LOCK';
ELSE
l_action := 'UNLOCK';
END IF;
l_what :=
'SYSTEM.TAS_USER_MAINT.LOCK_UNLOCK_ORACLE_USER('''
|| :old.emp_id
|| ''','''
|| l_action
|| ''');';
DBMS_JOB.SUBMIT (JOB => l_job, WHAT => l_what);
This stopped working, not sure why after the 19c Upgrade. So, I attempted to rewrite as an execute immediate of the package procedure itself... this also fails.