triggers

Hi, I have a trigger to keep a log of people in my app. the trigger goes like this :

CREATE OR REPLACE TRIGGER MY_TABLE_t
AFTER INSERT or UPDATE or DELETE on AMEUBLEMENT DECLARE
U_N VARCHAR2(50):= user;
T_N VARCHAR2(50):= 'MY_TABLE';
BEGIN
IF INSERTING THEN
        insert into LOG_TABLE values (U_N, T_N, 'insert', SYSDATE); END IF;
IF UPDATING THEN
        insert into LOG_TABLE values (U_N, T_N, 'update', SYSDATE); END IF;
IF DELETING THEN
        insert into LOG_TABLE values (U_N, T_N, 'delete', SYSDATE); END IF; END;
/

Here's a desc of the LOG_TABLE :

Name                                      Null?    Type
----------------------------------------- -------- ------------
USER                               NOT NULL VARCHAR2(30)
TABLEACTION                               NOT NULL VARCHAR2(30)
ACTION                                    NOT NULL VARCHAR2(25)
DATEACTION                                NOT NULL DATE

For this it works well but now i'd also like to keep the PK (sometimes more than one...) of the occurence consulted.

How can I do that ?

Thanks, Louis

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 23 2000 - 15:27:04 CDT