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 (