Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: "oracle_l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Jul 2009 11:38:31 -0500 (CDT)
Hey Steve,
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...
Rich
> 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 :
--
http://www.freelists.org/webpage/oracle-l
Other related posts: