Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Feb 2005 19:46:56 +0100
Message-ID: <ifvm11h5htct5u18edko7qlc0dpnjvj9oi@4ax.com>


On 22 Feb 2005 06:08:56 -0800, "dfosgate_at_llbean.com" <dfosgate_at_llbean.com> wrote:

>When run PL/SQL get the following error:
>DECLARE
>*
>ERROR at line 1:
>ORA-06502: PL/SQL: numeric or value error: character string buffer too
>small
>ORA-06512: at "SYS.UTL_FILE", line 611
>ORA-06512: at line 163
>ORA-06512: at line 508

Which simply means you have a record with a string longer than 15 bytes.
You didn't look the error up, did you?

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Feb 22 2005 - 12:46:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US