ORA-06530: Reference to uninitialized composite
From: Stephanie <stephanie.m.deantoni_at_efunds.com>
Date: 10 Dec 2001 10:45:13 -0800
Message-ID: <2d7a48ee.0112101045.6d223307_at_posting.google.com>
FROM acct_nbr
WHERE ordr_id = i_ordr_id
ORDER BY acct_nbr_nbr;
END LOOP;
END;
END; Received on Mon Dec 10 2001 - 19:45:13 CET
Date: 10 Dec 2001 10:45:13 -0800
Message-ID: <2d7a48ee.0112101045.6d223307_at_posting.google.com>
IS
CURSOR acct_nbr_cur IS
SELECT
ordr_id, acct_nbr_nbr, acct_nbr, rej_ind, print_ind
FROM acct_nbr
WHERE ordr_id = i_ordr_id
ORDER BY acct_nbr_nbr;
rownumber NUMBER DEFAULT 1;
BEGIN
FOR row IN acct_nbr_cur
LOOP
o_ordr_id(rownumber) := row.ordr_id; o_acct_nbr_nbr(rownumber) := row.acct_nbr_nbr; o_acct_nbr(rownumber) := row.acct_nbr; o_rej_ind(rownumber) := row.rej_ind; o_print_ind(rownumber) := row.print_ind; rownumber := rownumber + 1;
END LOOP;
END;
END; Received on Mon Dec 10 2001 - 19:45:13 CET