ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind.
I'm running a table conversion for some changes
It is pulling data from an existing table and placing it in a _PRJ version with no changes other than creating a new account number. The source table has already had it's data validated without error before this conversion happens.
I get through 357,402 rows and then get ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind.
I can't find any values out of whack in the source table (it was already validated when it was loaded).
Any ideas what can cause this?
Here's the loop that's doing it. CUST is the cursor, I set c_FetchLimit to 1 to find the row doing it.
open CUST;
<<FETCH_LOOP>>
LOOP
fetch CUST BULK COLLECT into CUSTH limit c_FetchLimit;
exit FETCH_LOOP when CUSTH.count = 0;
forall D in CUSTH.first..CUSTH.last
insert into CHBW_PRJ values CUSTH(D)
;
i_TotInsertCnt := i_TotInsertCnt + CUSTH.count;
commit;
exit FETCH_LOOP when CUSTH.count < c_FetchLimit;
CUSTH.delete;
END LOOP FETCH_LOOP;
close CUST;
Could this be an issue with the DB?
Edited by: user7385944 on May 31, 2013 7:28 AM