| ORA-06502: PL/SQL: numeric or value error [message #627850] |
Mon, 17 November 2014 08:36  |
Xandot
Messages: 235
Registered: January 2014
Location: India
|
Senior Member |
|
|
Hello,
I have create one validation for check the range of ":P101_value" (Datatype is varchar2(200) ) but when I write text in :P101_value and click to apply button than system raise error ORA-06502,Please Help me out.
if :P101_value not between :P101_LLimit and :P101_ULimit then
return 'Value must be between '||:P101_LLimit||' and '||:P101_ULimit;
else
return null;
end if;
Thanks,
Xandot
|
|
|
|
| Re: ORA-06502: PL/SQL: numeric or value error [message #627866 is a reply to message #627850] |
Mon, 17 November 2014 10:37  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Oracle
ORA-06502: PL/SQL: numeric or value error string
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 99 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.
Do these 3 item's datatypes match? If P101_VALUE is VARCHAR2, what are P101_LLIMIT and P101_ULIMIT?
BETWEEN suggests that you are, actually, comparing numbers. If that's so, why didn't you choose a NUMERIC FIELD (instead of TEXT)? If you still want to enter strings, are you aware of the fact that '14' is between '1' and '2'?
Did you run that page in debug mode? If not, perhaps you should have. It'll tell you what is going on and - hopefully - which part of it raises an error.
See whether everything you read above helps. If not, provide some more details which would enable us to simulate what you are doing and see what happens.
|
|
|
|
| Re: ORA-06502: PL/SQL: numeric or value error [message #627903 is a reply to message #627866] |
Tue, 18 November 2014 01:08 |
Xandot
Messages: 235
Registered: January 2014
Location: India
|
Senior Member |
|
|
In :P101_Value sometime it takes string and sometime it takes number value that's why datatype of :P101_Value is varchar2 but the other two are P101_LLIMIT and P101_ULIMIT numeric fields.
When the user insert a number into P101_value than the range validation working correctly but when user insert character than only error raised.
I am not able to change the datatype of :P101_Value because its database column.Is there any solution for this problem?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
