Trigger on logoff trouble
741904Mar 3 2010 — edited Mar 3 2010Hi to all,
I'd like to try setting a trigger on logoff event. But when I logoff either from the terminal and from the APEX's web igu admin nothing's added into the target table.
Any clue?
Thank.
Claude
------------------------------------------
The trigger code:
===========
CREATE OR REPLACE TRIGGER TrigLog
BEFORE LOGOFF ON CLASIE.SCHEMA
BEGIN
INSERT INTO TTRIG VALUES('Test');
END;
the table:
======
create table ttrig (message VARCHAR2(100));
No errors showned when creating both db objets.
My system:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production