Re: ORA-06502 error when returning varchar2...

From: Ana C. Dent <>
Date: Sun, 09 Mar 2008 00:40:38 GMT
Message-ID: <amGAj.5062$GW5.2774@newsfe12.phx>

"buu" <> wrote in

> this is only a core part of function and there is exception (when
> others) in int...
> oracle is XE
> what I did noticed now is when I put an any kind of hard-coded string
> as an return value, there is an error..
> is there possibility that 2005 (using
> Oracle.DataAccess.Client.OracleCommand object) does not support
> varchars as an return value?

Most anythig is possible.
I for 1 have no clue as to what you are doing to generate the error. Because you are not sharing completely what you are doing.

In your most recent post you got around to mudding the waters by adding VB.NET into the problem set.

Yes, you have a problem.
The problem is that you have not provided anything meaningful to allow anyone to guess at a solution.

Is there any type of implicit datatype conversion happening?

06502, 00000, "PL/SQL: numeric or value error%s" // *Cause: An arithmetic, numeric, string, conversion, or constraint error
// occurred. For example, this error occurs if an attempt is made to
// assign the value NULL to a variable declared NOT NULL, or if an
// attempt is made to assign an integer larger than 99 to a variable
// declared NUMBER(2).
// *Action: Change the data, how it is manipulated, or how it is declared so
// that values do not violate constraints. Received on Sat Mar 08 2008 - 18:40:38 CST

Original text of this message