FRM-40508: unable to insert record
Our Oracle Forms (11G) application can throw the insert failed error message FRM-40508 but no failed insert statement came with.
I want the Forms application is able to capture the failed insert statement so that I can figure out which table(s) involved for this failed insert action.
I am wondering if there is some programming codes in triggers at either block level or form level can handle this to display the failed insert statement.
any suggestion or idea about this is appreciated.
Thanks.