我写的一段SDE中A表的触发器代码，请批评！

create or replace trigger ptical_fiber_cable_line_insert
after insert on A739
for each row
declare
v_boolean number:=0;
v_objectid wilson.ptical_fiber_cable_line.pl_id_map%type;
cursor c_ptical_fiber_cable_line is select wilson.ptical_fiber_cable_line.pl_id_map from wilson.ptical_fiber_cable_line;
begin
open c_ptical_fiber_cable_line;
loop
fetch c_ptical_fiber_cable_line into v_objectid;
exit when c_ptical_fiber_cable_line%notfound;
if :new.objectid=v_objectid then
v_boolean:=1;
exit;
end if;
end loop;
close c_ptical_fiber_cable_line;
if v_boolean=1 then
update wilson.ptical_fiber_cable_line set pl_level=:new.级别,pl_mode=:new.所属区局 where wilson.ptical_fiber_cable_line.pl_id_map=:new.objectid;
else
insert into
wilson.ptical_fiber_cable_line(PL_ID_MAP,PL_ID,PL_TITLE,PL_BYNAME,PL_LEVEL,PL_JO_ID,PL_JO_NAME,PL_EP_ID,PL_EP_NAME,PL_TYPE,PL_LENGTH,PL_MODE,PL_SPAN,PL_BUILD_DATE,PL_DREDGE_DATE,PL_PROJECT_OF,PL_DELETE_MARK,PL_SAVE_MARK,PL_MODIFY_MARK,PL_REMARK1,PL_REMARK2,PL_REMARK3) values(:new.objectid,'null','null','null','光缆','null','null','null','null','null',0,'直埋',0,to_date('2003-01-01','yyyy-mm-dd'),to_date('2003-01-01','yyyy-mm-dd'),'null','null','null','null','null','null','null');
end if;
end;

这是pl/sql的开发吗？

写Ao程序的时候顺便写了这么个程序，其实AO的开发是离不开底层对SDE的Api的调用的

<P>在哪里啊</P>

<P>没有吗？</P>