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?