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

From: Marc Perkowitz <mperkowitz_at_twjconsulting.com>
Date: Wed, 19 Dec 2001 11:05:05 -0800
Message-ID: <F001.003E0748.20011219105223@fatcity.com>

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). Received on Wed Dec 19 2001 - 13:05:05 CST