PL/SQL (MOSC)

MOSC Banner

Trying to set an event using trigger

in PL/SQL (MOSC) 2 commentsAnswered ✓

Hi

We have a 19c database in which we are trying to set an event using after startup trigger

create or replace trigger db_startup_trigger

 after startup on database

begin

 execute immediate 'alter system set events = '28500 trace name context forever, level 2 ';'

end;

But it is compiling with error


Warning: Trigger created with compilation errors.

SQL> show err

Errors for TRIGGER DB_STARTUP_TRIGGER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

2/49   PLS-00103: Encountered the symbol "28500" when expecting one of

     the following:

     * & = - + ; < / > at in is mod remainder not rem return

     returning <an exponent (**)> <> or != or ~= >= <= <> and or

     like like2 like4 likec between into using || multiset bulk

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