why the trigger created with compile errors [message #231669] |
Wed, 18 April 2007 00:46  |
iitraghu
Messages: 18 Registered: April 2007 Location: bengalore
|
Junior Member |

|
|
My aim was if i updated the rows in complex view it has effect
on the table from which the view was created.
here v1 is a view created from emp and dept tables.
1 create or replace trigger ins_of_upd_on_v1
2 instead of update on v1
3 for each row
4 begin
5 update emp set empno := :new.empno;
6* end;
SQL> /
Warning: Trigger created with compilation errors.
SQL> select * from v1;
EMPNO DEPTNO DEPTNO1
----- ------ -------
7369 20 20
7499 30 30
7521 30 30
7566 20 20
7654 30 30
7698 30 30
7782 10 10
7788 20 20
7839 10 10
7844 30 30
7876 20 20
EMPNO DEPTNO DEPTNO1
----- ------ -------
7900 30 30
7902 20 20
7934 10 10
1116 50 50
15 rows selected.
i want to update the last record in my view.
|
|
|
|
|
|
|
|
|
|
|
|