Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
I'm getting the above-referenced runtime error; dynamic SQL, fetching
into a set of nested tables using BULK COLLECT. Can't find anything in
docs or on MetaLink or Google; is this a mismatch between select-list
and number of nested tables (there are a lot of them in this procedure,
and I'm too lazy right now to match them up with the query!), or is due
to exceeding array size? I have tried LIMIT clause in FETCH ... BULK
COLLECT INTO, but no luck. Anyone familiar with this error?
Thanks,
![]() |
![]() |