Forum Stats

  • 3,770,440 Users
  • 2,253,113 Discussions


dipslay insert error with related table and statement in forms

3053701 Member Posts: 74
edited Apr 26, 2019 2:55AM in Forms Gruppe

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.