PL/SQL (MOSC)

MOSC Banner

ORA-1403 occurred using 'for loop' without 'into'.

edited Mar 5, 2014 12:00PM in PL/SQL (MOSC) 3 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center