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: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
