I am using Oracle forms 6i . I have a multi-data block. I have written commit_form in when-new-record-instance of the data block. When I launch the form on my instance the form does not open.
But when I comment out this code, the form opens on the instance. What could be the exact problem?
Also is there any condition that I can specify if the whole data block is null when I open the form?
I'm not sure why you would want to use the COMMIT_FORM in a When-New-Record-Instance (WNRI) trigger; do you really need your Form to call COMMIT_FORM everytime Forms instantiates a new record?
My quess is that you have more going on in the WNRI than just the COMMIT_FORM. Can you show us the code in your WNRI trigger? Is there a reason you need to commit when navigation moves from one record to another?