after

CREATE OR REPLACE TRIGGER buildnt_trigger AFTER INSERT or UPDATE or DELETE on buildnt FOR EACH ROW DECLARE V_RESULT clob; l_output varchar(1000); V_AREA number; BEGIN SELECT sde.st_astext(:new.SHAPE) INTO V_RESULT FROM dual; IF UPDATING THEN UPDATE SDE.BUILDNT_SYC SET SCALE = :new.SCALE,CHDATE = :new.CHDATE,ZH=:new.ZH,FWMC=:new.FWMC,FWCS=:new.FWCS,FWLX = :new.FWLX,SJLY=:new.SJLY,CJRQ=:new.CJRQ,XGRQ=:new.XGRQ,REMARK=:new.REMARK, STATUSFLAG=:new.STATUSFLAG,MATCHSTATUS=:new.MATCHSTATUS,HASSTREET=:new.HASSTREET,REGION=:new.REGION,DISTRICT=:new.DISTRICT,MATCHNAME=:new.MATCHNAME,CX=:new.CX,CY=:new.CY,X=:new.X,Y=:new.Y, PNCODE=:new.PNCODE,ALIASNAME=:new.ALIASNAME,ABBRNAME=:new.ABBRNAME,HISTORYNAME=:new.HISTORYNAME,SOURCE=:new.SOURCE,SECRET=:new.SECRET,ST_DZYSID=:new.ST_DZYSID,SHORTNAME=:new.SHORTNAME ,FLOOR=:new.FLOOR,SHAPE = V_RESULT WHERE BUIDGUID = :new.BUIDGUID; ELSIF inserting THEN INSERT INTO SDE.BUILDNT_SYC(OBJECTID, BUIDGUID, SCALE, CHDATE, ZH, FWMC, FWCS, FWLX, SJLY, CJRQ, XGRQ, REMARK, STATUSFLAG, MATCHSTATUS, HASSTREET, REGION, DISTRICT, MATCHNAME , CX, CY, X,Y, SHAPE, PNCODE, ALIASNAME, ABBRNAME, HISTORYNAME, SOURCE,SECRET, ST_DZYSID, SHORTNAME) VALUES(:new.OBJECTID, :new.BUIDGUID, :new.SCALE, :new.CHDATE, :new.ZH, :new.FWMC, :new.FWCS, :new.FWLX, :new.SJLY, :new.CJRQ, :new.XGRQ, :new.REMARK, :new.STATUSFLAG, :new.MATCHSTATUS, :new.HASSTREET , :new.REGION, :new.DISTRICT, :new.MATCHNAME , :new.CX, :new.CY, :new.X,:new.Y, V_RESULT, :new.PNCODE, :new.ALIASNAME, :new.ABBRNAME, :new.HISTORYNAME, :new.SOURCE,:new.SECRET, :new.ST_DZYSID, :new.SHORTNAME); ELSIF deleting then DELETE FROM SDE.BUILDNT_SYC WHERE OBJECTID = :old.OBJECTID; END IF; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Error in trigger:' || sqlerrm); l_output := 'Error in trigger:' || sqlerrm; INSERT INTO LOG_OPERATE(LOG_MSG)VALUES(l_output); END; 这个是写的触发器

触发条件是 对数据库表的增删改 操作 都会触发

这个函数 是oracle 装的空间扩展支持，在plsql窗口执行得出来的结果是好的