I have a new query again.
In my form ( form builder-oracle 6i ) , there are many push buttons like 'NEW', 'QUERY', EXECUTE', 'MODIFY', 'CLEAR', 'SAVE', 'EXIT'.
When I click on 'SAVE' & if it gets saved successfully (that is FRM-40400 :transaction complete: records applied & saved.) & after that if I click on 'EXIT' button, it gets back to the previous form.
This is fine.
But when I click on 'SAVE' & if it does not gets saved successfully (that is FRM-40508 : Oracle Error: Unable to insert record) & after that if I click 'EXIT' button, it completely gets exit from all the form & closes.
I want it to just exit the present form & go back to the previous form & not exit completely.
Trigger for 'EXIT' :
Why is it getting exit completely?
How to make it work fine?