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

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Eriks.

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

Answered by: Connor McDonald - Last updated: May 26, 2020 - 9:44 am UTC

Category: Database Development - Version: 19.5

Viewed 100+ 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 we 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 Review

More to Explore

PL/SQL

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