A script-enabled browser is required for this page to function properly.

CLEAR_BLOCK Built-in

Description

Causes Oracle Forms to remove all records from, or "flush," the current block.

Syntax

PROCEDURE CLEAR_BLOCK;

PROCEDURE CLEAR_BLOCK
(commit_mode NUMBER);

Built-in Type restricted procedure

Enter Query Mode no

Parameters

If the end user has made changes to records in the current block that have not been posted or committed, Oracle Forms processes the records, following the directions indicated by the argument supplied for the commit_mode parameter:

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

ASK_COMMIT
Oracle Forms prompts the end user to commit the changes during CLEAR_BLOCK processing.
 
DO_COMMIT
Oracle Forms validates the changes, performs a commit, and flushes the current block without prompting the end user.
 
NO_COMMIT
Oracle Forms validates the changes and flushes the current block without performing a commit or prompting the end user.
 
NO_VALIDATE
Oracle Forms flushes the current block without validating the changes, committing the changes, or prompting the end user.

CLEAR_BLOCK Examples

** Built-in: CLEAR_BLOCK
** Example: Clears the current block without validation, and
** deposits the primary key value which the user
** has typed into a global variable which a
** Pre-Query trigger will use to include it as a
** query criterion.
** Trigger: When-New-Item-Instance
*/
BEGIN
IF :Emp.Empno IS NOT NULL THEN
:Global.Employee_Id := :Emp.Empno;
Clear_Block(No_Validate);
END IF;
END;
/*
** Trigger: Pre-Query
*/
BEGIN
Default_Value(NULL, 'Global.Employee_Id');
IF :Global.Employee_Id IS NOT NULL THEN
:Emp.Empno := :Global.Employee_Id;
END IF;
END;

CLEAR_FORM Built-in