Advice needed: Insert user in a field via TRIGGER

Hi all,

can someon tell me please how to write a trigger which fires on insert and writes the actual user-name in a field ?

I wrote one which is inserted with compilation errors ..

CREATE OR REPLACE TRIGGER BEFORE INSERT ON LEXIKON BEGIN
   SELECT USER INTO NEW.BENUTZER FROM DUAL; END AND I tried this one :

CREATE OR REPLACE TRIGGER BEFORE INSERT ON LEXIKON DECLARE
  dummy varchar)30);
BEGIN
   SELECT USER INTO :dummy FROM DUAL;
  NEW.BENUTZER = :dummy;
END But both didn't work..

Thanks in advance

Oliver Received on Tue Nov 17 1998 - 07:00:56 CST