RE: ORA-06502: PL/SQL: numeric or value error: character string b

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 19 Dec 2001 11:30:24 -0800
Message-ID: <F001.003E07C3.20011219111246@fatcity.com>

Mark,

Your friend does not say how large the variable is, being referenced by the 'out' parameter. My guess is that it is varchar2(256). Have him simply increase the size of the variable in the calling procedure to accomodate the data, and all should be well.

HTH Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, December 19, 2001 1:52 PM To: Multiple recipients of list ORACLE-L buffer too small

I am posting this for a co-worker. Anyone seen this before? Seems like there should be an easy answer to this. It's Oracle 8.1.7 on Redhat Linux.

Thanks,
Marc Perkowitz

I am receiving the following Oracle error from a PL/SQL procedure when it attempts to execute a line of code like this:

p_out_parameter (of type varchar2) := v_variable (of type varchar2(1023));

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

If the length of the string stored in v_variable is greater than 256 characters I get the error, otherwise I do not.

I have tried explicitly setting the type of p_out_parameter to a table column of type varchar2(2000), but I still get the error.

Apparently, the out parameter has a buffer capacity of 256 characters. Does anyone know how to increase the buffer capacity?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Marc Perkowitz
INET: mperkowitz_at_twjconsulting.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------