> CHARS_A, CHARS_B' INTO does not match returned column type
>
> What is the expected behavior, and what can I do to have it cast
> implicitly?

This is expected behaviour and you can't change it.

SY, SD.