• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6506
  • Last Modified:

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

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!
0
menkiz
Asked:
menkiz
1 Solution
 
menkizAuthor Commented:
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.
0
 
sujit_kumarCommented:
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.
0
 
riazpkCommented:
go_block('BlockName');
clear_block(do_commit);
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now