PL/SQL (MOSC)

MOSC Banner

Trigger underlying code no longer works correctly. Stored Proc / DBMS_JOB.Submit

in PL/SQL (MOSC) 3 commentsAnswered

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.

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