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


Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

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).

More to Explore


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