SQL Language (MOSC)

MOSC Banner

TRIGGER AFTER SERVERERROR ON DATABASE create duplicate entries in table

Hello,

we've created an after servererror trigger for statistics purpose. It's working fine but we see that the entry are duplicated into the target table which contains the informations of the trigger.

We've doubled check to see if the trigger wasn't doubled and it is unique.

Is this the default behaviour of ORACLE? Can someone explain this please?

We're in 19.3 under red hat

Here's the code:

CREATE TABLE CAUGHT_ERRORS

(

 ERROR_DATE TIMESTAMP(6),

 USERNAME  VARCHAR2(30 CHAR),

 DATABASE  VARCHAR2(30 CHAR),

 SESSION_ID NUMBER,

 HOSTNAME  VARCHAR2(256 CHAR),

 MODULE   VARCHAR2(4000 CHAR),

 ERROR_MSG  CLOB,

 ERROR_STMT CLOB

)

LOB (ERROR_MSG) STORE AS SECUREFILE (

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