Skip to Main Content

Deutsche

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

dipslay insert error with related table and statement in forms

3053701Feb 28 2019 — edited Apr 26 2019

when save the entries in forms but got FRM-40508: unable to insert record.

I want the error message display the failed insert statements so that I can narrow down to the related table (s) for troubleshooting.

Oracle suggests to check Display Error or Menu Option but our form application does not have them on it.

I may need to program the block trigger or something like that to capture the failed Insert statement.

any suggestion about the coding template and documentation is appreciated.

Comments
Post Details
Added on Feb 28 2019
2 comments
331 views