Re: ORA-06502 character string buffer too small

From: Damien Salvador <damien.salvador_at_via.ecp.fr>
Date: 29 Nov 2001 00:14:09 GMT
Message-ID: <slrna0aveg.i4b.damien.salvador@zen.via.ecp.fr>

On 28 Nov 2001 13:13:43 -0500, ilimbert <member_at_dbforums.com> a écrit:

>I have a similar problem with a pls procedure moved from 8.1.7 to 9i.
>When I pass text to two VARCHAR2 parameters in my procedure I get the
>ORA-06502 error instead of my desired html page of data. The same code
>works fine in my 8i database version.

I do not know about your specific problem, but maybe some hints. Indeed, we have a 8.7.0 on AIX. We've got a problem in some PL/SQL that was working fine on 8.1.5.

The error is also "character string buffer too small" and this is caused by Oracle when trying to use a passed parameter more than once. The solution was to store the parameter in a temporary variable, and then process that variable.

Support told us it should be ok on 8.7.2. We did not try that specific issue on 9i.

-- 
Damien

Received on Wed Nov 28 2001 - 18:14:09 CST