ORA-1403 occurred using 'for loop' without 'into'.
ORA-1403 error occurred at following source.
FOR CX IN ( | ||
SELECT NVL(CLOS_TP,'0') CLOS_TP | ||
FROM BB301T00 -- 위탁자일별집계내역 | ||
WHERE DT | = I_DT | |
AND DPT_CD = DECODE(I_PRBR,'508','008','524','024','624','024',I_PRBR) | ||
AND AC_GDS = K_TRST_GDS | ||
) LOOP | ||
T_CLOS_TP := CX.CLOS_TP; | ||
END LOOP; |
error message :
ORA-01403: no data found
ORA-06512: at "SHS.PBB_APL_ENS_BR_SUM_DL_DTL", line 82
So, i made testcase like following source, but i can not reproduce it, because there is no 'into' in for loop.
How can i resolve this problem?