| ORA-01403 FRM-40735: PRE-FORM in custom form [message #563819] |
Fri, 17 August 2012 05:59  |
debashish.panda
Messages: 2
Registered: August 2012
Location: India
|
Junior Member |
|
|
HI Team,
I have designed a custom form and deployed in Oracle CRM.
On click of the new custom form I am getting this message "ORA-01403 no data found"
Then click of details button getting
"
ORA-01403: no data found
--------------------------------------------------------------
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06502.
"
But the strange thing I observed is , It is working fine in other system.
Can anybody tell me , what could be the reason behind this??
Do I need to make some setup change OR to check any prerequisites.. (System Specific) ?
Regards
Debashish
|
|
|
|
|
|
| Re: payments [message #564960 is a reply to message #564767] |
Wed, 29 August 2012 14:16  |
 |
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.
"Other system" maybe used valid value (for example, there was a NUMBER datatype form item and "other system's user" entered 1 into it (which was actually a string, '1' and Oracle implicitly converted it into 1, a number). However, "this system's user" entered A (which is really 'A') into it and implicit conversion resulted in ORA-06502.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
