<div>
I believe that one can change the satus of the blocks not to be committed to 'QUERY' and then commit the form, but I believe that this is a roundasbout way and want to know if there is not a more direct approach.
</div>


I believe that one can change the satus of the blocks not to be committed to 'QUERY' and then commit the form, but I believe that this is a roundasbout way and want to know if there is not a more direct approach.

<div>
There is no way to commit a Block Only. But you can try defining a transaction as autonomous and then use forms_ddl('commit') for that transaction.
</div>


There is no way to commit a Block Only. But you can try defining a transaction as autonomous and then use forms_ddl('commit') for that transaction.

<div>
<div class="content wysiwyg-content">
How do I commit one block of a muti-block form in Oracle Forms? &nbsp;I know that the COMMIT command commits the entire form, but I have a requirement to commit only one block.<br />
<br />
Please help!
</div>
</div>


How do I commit one block of a muti-block form in Oracle Forms?  I know that the COMMIT command commits the entire form, but I have a requirement to commit only one block.

Please help!

How to commit one block of a muti-block form in Oracle Forms

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.