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

[Jiths]

Hi,

I have a Windows based application which is connecting to the Oracle database. I have two servers with the below configurations
Server1: Windows 2003 Server R2, Oracle 10g client (10.2.0.1), ODP.NET (10.1.0)
Server2: Windows 2000 Server, Oracle 10g client (10.1.0.4), ODP.NET (10.1.0)

When I use my application to fetch a data using Stored Procedure, the Server1 throws an exception: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small." But the same code gives the desired result when run in Server2.

Could you please suggest me a solution or a possible work around.

Thanks,
Jiths

 

[Marco Kalter]

Perhaps there is a bind variable for a varchar2 parameter that is declared as otString? This can only hold up to 4000 bytes of character data. You can declare it as otPLSQLString to retrieve up to 32KB of character data.