oracle使用dblink和cursor更新不同数据库的记录

一、部分SQL文件内容：
drop public database link sde_link;
create public database link sde_link connect to "sde" identified by "sde" using 'zcserver';
select zdid from sde.nzhxm@sde_link nzhxm;

declare 
       cursor cursor1 IS select t.zdid as zdid from sde.zdxm@sde_link t where (t.zdid is not null or t.zdid <> '' or t.zdid <> ' '); 
       zdid sde.zdxm.zdid@sde_link%TYPE; 
begin 
       if not curs