--通过游标插入字段类型为long的数据
Declare
CURSOR bcur
IS SELECT hdsmalappid,CHANGMIAOSHU from HDSMALAPP@ftmaximotest;
brec bcur%ROWTYPE;
BEGIN
insert into HDSMALAPP (HDSMALAPPID,
DESCRIPTION,
ORGID,
SITEID,
HASLD,
ROWSTAMP,
REPORTEDBY,
REPORTDATE,
APPNUM,
CMTYPE,
WCMPERSON,
FINDPERSON,
DATE1,
DATE2,
DATE3,
WCMMEMO,
YSMEMO,
YSPERSON,
APPTYPE,
STATUS,
A_MAJOR,
BUMEN,
BEIZHU,
BTMS,
TZBH,
TXTIME,
PZTIME,
SHENHEREN,
PIZHUNREN)
select HDSMALAPPID,
DESCRIPTION,
ORGID,
SITEID,
HASLD,
ROWSTAMP,
REPORTEDBY,
REPORTDATE,
APPNUM,
CMTYPE,
WCMPERSON,
FINDPERSON,
D