17,140
社区成员




把空行去掉试试,因为在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;
/
[Quote=引用楼主 yuzhongcao 的帖子:]
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>