Trigger program to track user information [message #588328] |
Tue, 25 June 2013 01:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/355bb538d35fb7470904ba631c6186c8?s=64&d=mm&r=g) |
rsb.oracle
Messages: 37 Registered: April 2013 Location: Chennai
|
Member |
|
|
Hello everyone ;
I have a trigger program to track updated information's on perks column.
i am failing to finish systime in my trigger program.
SQL> desc user_track;
Name Null? Type
----------------------------------------- -------- ----------------------------
EID NUMBER
ENAME VARCHAR2(15)
OLD_PERKS NUMBER
NEW_PERKS NUMBER
UNAME VARCHAR2(15)
ACTION_DATE DATE
ACTION_TIME DATE
SQL> create or replace trigger tri_track
2 After UPDATE ON EMP
3 FOR EACH ROW
4 BEGIN
5 insert into user_track(EID,ENAME,OLD_PERKS,NEW_PERKS ,UNAME,ACTION_DATE,ACTION_TME) values
6 (:old.eid, :old.ename , :old.perks, :new.perks,user, sysdate, to_char(sysdate , 'HH24:MI:SS')
7 from dual;
8 end;
9 /
Warning: Trigger created with compilation errors.
SQL> show errors;
Errors for TRIGGER TRI_TRACK:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PL/SQL: SQL Statement ignored
3/95 PL/SQL: ORA-00917: missing comma
|
|
|
|
Re: Trigger program to track user information [message #588332 is a reply to message #588329] |
Tue, 25 June 2013 01:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/355bb538d35fb7470904ba631c6186c8?s=64&d=mm&r=g) |
rsb.oracle
Messages: 37 Registered: April 2013 Location: Chennai
|
Member |
|
|
I done it !
create or replace trigger tri_track
2 After UPDATE ON EMP
3 FOR EACH ROW
4 BEGIN
5 insert into user_track(EID,ENAME,OLD_PERKS,NEW_PERKS ,UNAME,ACTION_DATE,ACTION_TIME)
6 values
7 (:old.eid, :old.ename , :old.perks, :new.perks,user, sysdate, to_char(sysdate, 'HH24:MI:SS'));
8 end;
9 /
Trigger created.
|
|
|
|