Re: error ora-06502
From: Precisely Fred <f_puhan_at_precise.com>
Date: Sun, 09 Jun 2002 14:43:43 -0400
Message-ID: <f_puhan-45C648.14434309062002_at_vienna7.his.com>
Date: Sun, 09 Jun 2002 14:43:43 -0400
Message-ID: <f_puhan-45C648.14434309062002_at_vienna7.his.com>
In article <1023642521.241988_at_seux119>, "Sanluki" <rmoralesm_at_supercable.es> wrote:
> What is that error: "ora-06502"?
> Thanks
A simple lookup in the Oracle Messages manual, or on Technet would have shown you
ORA-06502 PL/SQL: numeric or value errorstring
Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 88 to a variable declared NUMBER(2).
Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
-- The underscore character does not belong in my address. You know the drill... *** Anyone sufficiently smart enough to configure and use USEnet for research should be smart enough to Read The Freakin' Documentation!Received on Sun Jun 09 2002 - 20:43:43 CEST