Skip to Main Content
  • Questions
  • ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Eriks.

Asked: May 25, 2020 - 12:07 pm UTC

Last updated: May 26, 2020 - 9:44 am UTC

Version: 19.5

Viewed 1000+ times

You Asked

This is just weird. It works fine on 12.1. On version 19 it requires the "workaround" used in foo3.

with LiveSQL Test Case:

and Connor said...

I suspect that is a bug. I reproduced your findings with 19.6, and max_string_size has no bearing on the results.

I'd recommend you log a bug with Support. (Bugs carry more weight if backed by a customer than if I log it).

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library