"SQL Statement ignored" and "ORA-01733: virtual column not allowed here" errors

[samyuktha takkellapati]

create or replace trigger emp_trigger
   after update or delete on employee 
   for each row
begin
 if updating then
     insert into empupdate(empno,ename,job,mgr,sysdate,sal,comm,deptno) values(:old.empno,:old.ename,:old.job,:old.mgr,:old.hiredate,:old.sal,:old.comm,:old.deptno);
elsif deleting then 
     insert into empdelete(empno,ename,job,mgr,sysdate,sal,comm,deptno) values(:old.empno,:old.ename,:old.job,:old.mgr,:old.hiredate,:old.sal,:old.comm,:old.deptno);
end if;
end;
/

[Please use CODE tags when posting source code. Thanks! --pbmods]

error is

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/6 PL/SQL: SQL Statement ignored
3/48 PL/SQL: ORA-01733: virtual column not allowed here
5/6 PL/SQL: SQL Statement ignored
5/48 PL/SQL: ORA-01733: virtual column not allowed here

[pbmods]

Changed thread title to better describe the problem (did you know that threads whose titles contain phrases such as 'plz help' actually get FEWER responses?).

Moving to the Oracle forum....

[debasisdas]

Use this code.
It has been tested.

CREATE OR REPLACE TRIGGER emp_trigger after UPDATE OR DELETE ON emp FOR each row
begin
IF updating then
     INSERT INTO empupdate(empno,ename,job,mgr,hiredate,sal,comm,deptno) VALUES(:old.empno,:old.ename,:old.job,:old.mgr,:old.hiredate,:old.sal,:old.comm,:old.deptno);
elsif deleting then
     INSERT INTO empdelete(empno,ename,job,mgr,hiredate,sal,comm,deptno) VALUES(:old.empno,:old.ename,:old.job,:old.mgr,:old.hiredate,:old.sal,:old.comm,:old.deptno);
end IF;
end;
 

ERROR IN YOUR CODE
----------------------------------------
1.column name can;t be sysdate as it is a PSEUDO COLUMN