FETCH c1 INTO tmp, v_name; EXIT WHEN c1%NOTFOUND;这样才行。
EXIT 语句要紧接着 PETCH 语句 而不能放在输出纪录语句之后!!
OPEN cur_GetQryPhone FOR t_vSQL; LOOP FETCH cur_GetQryPhone INTO t_vValue; EXIT WHEN cur_GetQryPhone%NOTFOUND; cp_hb_inn_split_string(randnum, '$', t_vValue, 'QRYPHONE', ErrMsg);
fetch语句之后,应该立即执行exit语句,判断是否退出!
INTO tmp, v_name;
EXIT WHEN c1%NOTFOUND;这样才行。
而不能放在输出纪录语句之后!!
LOOP
FETCH cur_GetQryPhone
INTO t_vValue;
EXIT WHEN cur_GetQryPhone%NOTFOUND;
cp_hb_inn_split_string(randnum,
'$',
t_vValue,
'QRYPHONE',
ErrMsg);
END LOOP;这是一个典型的例子!