Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

From: Rich Jesse <>
Date: Thu, 30 Jul 2009 11:38:31 -0500 (CDT)
Message-ID: <>

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


> 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 :

Received on Thu Jul 30 2009 - 11:38:31 CDT

Original text of this message