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.