create or replace trigger zsf
after insert on BD_LJJ_JBXXB
declare
stmt varchar2(200);
begin
stmt := 'insert into FK_LJJ_GSH_JBXXB select * from BD_LJJ_JBXXB t where t.rysid in
(select rysid from GSH_JBXXB)
EXECUTE IMMEDIATE stmt;
end zsf_py_cj_bj;
after insert on BD_LJJ_JBXXB
declare
stmt varchar2(200);
begin
stmt := 'insert into FK_LJJ_GSH_JBXXB select * from BD_LJJ_JBXXB t where t.rysid in
(select rysid from GSH_JBXXB)
EXECUTE IMMEDIATE stmt;
end zsf_py_cj_bj;
这是我的代码:create or replace trigger tri_bd_ljj_jbxxb
after insert on BD_LJJ_JBXXB
declare
stmt varchar2(200);
begin
stmt := 'insert into FK_LJJ_GSH_JBXXB LJJSFZHM,LJJLJRYXM,LJJXB,LJJCSRQ,LJJYJSSX,LJJJTZZ,LJJLDJYQSRQ,LJJLDJYZZRQ,LJJLDJYQX,LJJXP select LJJSFZHM,LJJLJRYXM,LJJXB,LJJCSRQ,LJJYJSSX,LJJJTZZ,LJJLDJYQSRQ,LJJLDJYZZRQ,LJJLDJYQX,LJJXP from BD_LJJ_JBXXB t where t.rysid in
(select rysid from GSH_JBXXB)
EXECUTE IMMEDIATE stmt;
end tri_bd_ljj_jbxxb;其中ljjxp是blob型,执行时说有编译错误