Ora-6502: character string buffer too small

From: <raas.no_spam_at_interware.hu>
Date: 23 Mar 2001 13:09:28 GMT
Message-ID: <99fhu8$5n2$1@proxy.interware.hu>

Hi,

FUNCTION x (nnn in number, sss in varchar) RETURN NUMBER IS
BEGIN
RETURN(1);
END; and when I try to

SELECT z_id,x(z_id,z_sss) from z

Oracle (8.1.7) reports (after a few dozen rows)

ERROR:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Table 'z' is an IOT.

It always stops at the same record, while there's no significant difference between the last record displayed and the one that isn't.

What possible reasons are there for this? Any help would be appreciated.

regards
raas Received on Fri Mar 23 2001 - 07:09:28 CST