This content has been marked as final. Show 2 replies
I am new with Oracle Forms.
I am developing an application using Oracle 10g express and forms 6i.
Can somebody please guide me regarding code under SAVE button(I have placed some push buttons on form for add_new, Save, Reset ect).
I am trying to handle DUPLICATE_RECORDS AND NULL_VALUES through this code which is in ON_ERROR form trigger
if dbms_error_code in (-1400, -1407) then
elsIF dbms_error_code='-00001' then
and code under SAVE button is
but even form is prompting for duplicate value or null value, Alert_save is showing as record has been saved.
My question is how I can be sure that record has been saved actually?????
I have tried to check :SYSTEM.FORM_STATUS and it return CHANGED .
is there any approach I should use, any sample piece of code will be much appreciated.