Getting error while insert in forms 6i application
hi,
Software/Hardware used:
forms 6i ,oracle 10g
i have a database block on my form. the table to which it belongs is having one field naming - 'RETURN' .
so at the time of insertion it is giving error as Oracle error-Unable to insert record' and the error is unique constraint violated, but at the same time the record is getting inserted into the database.
can anybody tell me st abt this behavior of forms and also how can i suppress the database error window poping up on screen.
(system.message_level doesn't help).
Software/Hardware used:
forms 6i ,oracle 10g
ASKED:
November 13, 2009 11:01 AM
UPDATED:
November 13, 2009 4:47 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
I don’t think you should try to suppress the error message, but try to find the root cause of the error.
It is possible that your form is trying to insert the record twice, and that’s why you are getting the unique constraint violated error. The first thing I would do is review the code of the block triggers (pre-insert, on-insert and post-insert).