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).
