1:如下oracle存储过程(同事发现):
//*************************************************************************************//
create or replace procedure test is
strTaskID varchar2(50):='123321';
CURSOR Cursortt is SELECT * FROM T_FCVSTASK where strTaskID = strTaskID and 1=1;
ccclip Cursortt%rowtype;
begin
open Cursortt;
loop
fetch Cursortt into ccclip;
exit when Cursortt%notfound;
strTaskID := '123';
end loop;
end test;
//*************************************************************************************//
结论: 此问题确实存在, 但是平时我们因该按oracle常规写比如以上变量:v_strTaskId