Re: Ora-6502: character string buffer too small

What is the structure of table z?

Martin

raas.no_spam_at_interware.hu wrote:
>
> 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 - 15:53:17 CST