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