关于long raw即blob存取过程怎样做

[DYFDWX]

我现在有一张表emp(id varchar2(5),zp(long raw))我现在要建另外一张表对其备份(emp_bf(id varchar2(5),zp(long raw)))
reate or replace procedure pd_emp_copy(as_id in number) is
lbl_zp blob;
begin
insert into emp_bf(id)
select id from emp where id=as_id;
select zp into lbl_zp from emp where id=as_id;
update emp_bf
set zp=lbl_zp
where id=as_id;
commit;
end;

其中红色的通不过，请各位帮帮忙

[人生无悔]

create or replace procedure pd_emp_copy(as_id in number) is
row int:=0;
begin
  select count(1) into row from emp_bf where id=as_id;
  if row=0 then 
    insert into emp_bf(id,zp) select id,zp from emp;
    commit;
  end if;
end;

[DYFDWX]

insert into rs.empzp(zp)
select zp from rs.empzp@fdrs where empid=cur.empid;

PROCEDURE RS.PD_EMP_ADD 编译错误

错误: PL/SQL: ORA-00932: 不一致的数据类型: 要求 NUMBER 得到的却是 BINARY
行: 17
文本: select zp from rs.empzp@fdrs where empid=cur.empid;

错误: PL/SQL: SQL Statement ignored
行: 16
文本: insert into rs.empzp(zp)