Re: ORA-06502 PL/SQL character string buffer too small

renemuehle_at_gmx.de (Ren? M?hle) wrote in message news:<2943356f.0408240306.5c3a18b6_at_posting.google.com>...

I have found the problem. It is located in the definition of the type.

<%_at_ plsql parameter="p_perssurname" type="comp.faulttab.perssurname%TYPE"
default="''"%>
This compiles without a problem.

<%_at_ plsql parameter="p_perskeysavailableat" type="comp.faulttab.perskeysavailableat%TYPE"
default="''"%>
This doesn't compile and create the error: ORA-20006: "frsys_updatereport.psp": compilation failed with the following errors.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

<%_at_ plsql parameter="p_perskeysavailableat" type="VARCHAR2"
default="''"%>
This also compiles without a problem. The row comp.faulttab.perskeysavailableat is defined as VARCHAR2.

It seams there is a strict limit for the lenght of the name (string) in the type-declaration. Anyone there who knows about such restrictions and may know how to change this limit? Received on Wed Aug 25 2004 - 14:37:06 CEST