Database Administration (MOSC)

MOSC Banner

Invalid triggers

edited Nov 14, 2012 1:55AM in Database Administration (MOSC) 7 commentsAnswered
hi i tried to compile this invalid trigger but getting the following error. can you please guide me how could i solve this issue. i just did a refresh .

SQL> alter TRIGGER IMMSETUP.WJSBUSTG compile;
 
Warning: Trigger altered with compilation errors.
 
SQL> show err
Errors for TRIGGER IMMSETUP.WJSBUSTG:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
20/2     PL/SQL: Statement ignored
20/10    PLS-00371: at most one declaration for 'WJSSPPK.GV_STEPSUPDATED'
         is permitted
 
SQL>

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