FRM-40508 - unable to insert record [message #86040] |
Tue, 24 August 2004 17:45 |
Arpit
Messages: 99 Registered: March 2001
|
Member |
|
|
Hi,
I'm having an FORM3.0 application where it insert and updates were working fine and all of sudden started getting this error message
FRM-40508: ORACLE error -- unable to INSERT record
No changes have been made to the table used by the db_blk and .frm version was all working fine before.
PLEASE HELP ME ASAP!
Thx!
|
|
|
Re: FRM-40508 - unable to insert record [message #86044 is a reply to message #86040] |
Tue, 24 August 2004 20:38 |
Narendra K.
Messages: 18 Registered: June 2003
|
Junior Member |
|
|
When u get this error, press Shift-F1 key to
display the detailed error message. Before
pressing this key, please ensure that there
is no When-Others trigger defined in the form.
There seems to be space problem or validation
error.
The second solution is, write ON-ERROR trigger
at form level and display the error_text.
I am sure, it will solve your problem.
Have a nice day,
-Narendra,
|
|
|
|