Trigger "AFTER LOGON ON SCHEMA" never works.

From: Lav Kovacic <lako_at_inet.hr>
Date: Tue, 28 Oct 2003 09:00:07 +0100
Message-ID: <bnl7f6$r0j$2@newstree.wise.edt.ericsson.se>

I have created a trigger with the following script:

CREATE OR REPLACE TRIGGER "LAV"."PROBA"
AFTER LOGON ON SCHEMA
BEGIN INSERT INTO aa_log values (

10000,
'Trigger',

1,
'AAA',
'BBB');
COMMIT; END; User that creates the trigger has "CREATE TRIGGER" and "ADMINISTER DATABASE TRIGGER" privileges.

The trigger is successfully compiled and enabled.

The Insert command (from triggers body) was tested separately, and it works.

However, when the user performs logon, nothing is inserted into the table, so I conclude that the trigger is not fired. What should I do to make it work?

Server: Solaris 9, Oracle 9i
Client: Win2k, SP4

Thanks in advance,

Lav Received on Tue Oct 28 2003 - 02:00:07 CST