游标为什么不继续了??????急!!!!!
我有这样一个游标,如下:
DECLARE BX_CUR1 CURSOR FOR SELECT ct_bxm,am_clf,am_rgf,am_gcf,am_qtf
FROM jx_wh_bx
WHERE (ct_bxm LIKE :Ls_bxm1) and (length(ct_bxm) > 6);
OPEN BX_CUR1;
FETCH BX_CUR1 INTO :Ls_bxm,:Ld_clf,:Ld_rgf,:Ld_gcf,:Ld_qtf;
DO WHILE SQLCA.SQLCODE = 0
Ll_newrow = dw_detail.insertrow(0)
dw_detail.ScrollToRow(Ll_newrow)
dw_detail.setitem(Ll_newrow,'ct_bxm',Ls_bxm)
dw_detail.setitem(Ll_newrow,'am_clf',Ld_clf)
dw_detail.setitem(Ll_newrow,'am_rgf',Ld_rgf)
dw_detail.setitem(Ll_newrow,'am_gcf',Ld_gcf)
dw_detail.setitem(Ll_newrow,'am_qtf',Ld_qtf)
FETCH BX_CUR1 INTO :Ls_bxm,:Ld_clf,:Ld_rgf,:Ld_gcf,:Ld_qtf;
LOOP
CLOSE BX_CUR1;
实际上应该有多于2条记录的,为什么只出来一条!
我用的数据库是Oracle 8.0.5!!!!