日期:2014-05-17 浏览次数:21060 次
SQL> create table dss_dev.a_1(a1 varchar(5) primary key not null,a2 varchar(5));
Table created
SQL> create table dss_dev.b_1(b1 varchar(5) primary key not null,b2 varchar(5));
Table created
SQL>
SQL> create or replace trigger dss_dev.a_test1_1
2 after insert
3 on a_1
4 for each row
5
6 begin
7
8 insert into b_1(b1,b2) values('1','2');
9
10 end ;
11 /
Trigger created
SQL>
------解决方案--------------------
把空行去掉试试,因为在sqlplus中连续的两个空行就会导致语句结束.
CREATE OR REPLACE TRIGGER WL08CK1.A_TEST1
AFTER INSERT ON WL08CK1.A
FOR EACH ROW
BEGIN
INSERT INTO B (B1, B2) VALUES ('1', '2');
END;
/
------解决方案--------------------
违反的主键约束所以出错!