Getting error while insert in forms 6i application

5 pts.
Tags:
Oracle Forms
Oracle Forms 6i
hi,
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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).
    70,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following