Thursday, 17 April 2014

Username / Benutzername speichern

Namen des aktuellen Benutzers über Trigger abspeichern / save name of current user via trigger:

create or replace TRIGGER wfe_sk_strassenkarte_I  BEFORE INSERT ON wfe_sk_strassenkarte
FOR EACH ROW

DECLARE
begin   
     SELECT USER_MGMT.GETVALUE('LOGIN_NAME') INTO :new.visum FROM dual;
END;


Map 2103, SP2

No comments:

Post a Comment