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

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Thu, 30 Jul 2009 11:38:31 -0500 (CDT)
Message-ID: <2dfa6ff0676c1cadcc737270707071e9.squirrel_at_society.servebeer.com>

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

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

This message: [ Message body ]
Next message: Adam Musch: "Re: more sql help - find minimum"
Previous message: Barbara Baker: "Re: more sql help - find minimum"
In reply to: Steve Baldwin: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Next in thread: Steve Baldwin: "Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Reply: Steve Baldwin: "Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message