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

Tom,
At first, he said, no, he had checked that, but (as we know often happens), he rechecked and saw that a higher level calling procedure was set at the smaller size. So your suggestion did lead to the solution.

Thanks!
Marc Perkowitz

• Original Message ----- To: <ORACLE-L_at_fatcity.com> Cc: <mperkowitz_at_twjconsulting.com> Sent: Wednesday, December 19, 2001 1:08 PM buffer too small

> 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-----
> From: Marc Perkowitz [mailto:mperkowitz_at_twjconsulting.com]
> Sent: Wednesday, December 19, 2001 1:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-06502: PL/SQL: numeric or value error: character string
> 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: 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).