17,382
社区成员




create or replace procedure X_SD_site_IO_test
is
cursor c_inout_bound is select * from FCT_IN_OUT_DATA FOR UPDATE;
tmp_site_l varchar(400) ;
begin
for c_row in c_inout_bound loop
tmp_site_l := '';
select NAME1 into tmp_site_l from(
SELECT dim_rma.NAME name1, dim_rma.rma_center
FROM DIM_R_CENTER dim_rma
WHERE c_row.SOURCE_PROFILE_ID = dim_rma.ID order by rma_center desc)
where rownum = 1 ;
tmp_site_l:= NVL(tmp_site_l, 'Others');
UPDATE FCT_IN_OUT_DATA SET SOURCE_Site = tmp_site_l WHERE CURRENT OF c_inout_bound;
end loop;
end;
/
select NAME1 into tmp_site_l from(
SELECT dim_rma.NAME name1, dim_rma.rma_center
FROM DIM_R_CENTER dim_rma
WHERE c_row.SOURCE_PROFILE_ID = dim_rma.ID order by rma_center desc)
where rownum = 1 ;
上面使用游标的select错误出在哪儿??各位大神