Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Date: Thu, 30 Jul 2009 11:38:31 -0500 (CDT)
If you're worried about CHAR vs BYTE, is there a reason you're not using NCHAR/NVARCHAR2? Also, I'd think passing your static parameter as (N'Über') would also be ideal to help prevent casting.
Just a thought...
> We have NLS_LENGTH_SEMANTICS set to CHAR at the DB level.
> It seems that it is somehow losing the nls_char_semantics setting of
> the package. The statement it was failing on is :