Press "Enter" to skip to content

Using CLEAR_BLOCK To Prevent Save Confirmation Dialogs In Oracle Forms

Clear_Block built-in clears all records from the current data block and if the user had made some changes in records which have not been committed, then Oracle Forms processes the records depending on the argument passed to the Clear_Block procedure.

Syntax

CLEAR_BLOCK (commit_mode NUMBER);

commit_mode is optional action parameter takes the following possible constants as arguments:

ASK_COMMIT
Oracle Forms prompts the user to commit the changes before clearing the block.

DO_COMMIT
Oracle Forms validates the changes, performs a commit, and clears the current block without prompting the user.

NO_COMMIT
Oracle Forms validates the changes and clears the current block without performing a commit or prompting the user.

NO_VALIDATE 
Oracle Forms clears the current block without validating the changes, committing the changes, or prompting the user.

Example

Assume that a push button is on a canvas with lable ‘Execute Query’ and whenever user clicks on that execute query button, it clears the block first without prompting to user then re-executes the query.
BEGIN
Clear_Block(No_Validate);
Execute_Query;
END;
Example of Clear_Block in Oracle Forms

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

2 Comments

  1. After the line Commit_Form; add below two lines:
    Go_Block('yourblock');
    Clear_Block(no_validate);

Leave a Reply

Your email address will not be published. Required fields are marked *