POST built-in Oracle Forms

37178

Writes data in the form to the database, but does not perform a database commit. Form Builder first validates the form. If there are changes to post to the database, for each block in the form Form Builder writes deletes, inserts, and updates to the database.Any data that you post to the database is committed to the database by the next COMMIT_FORM that executes during the current Runform session. Alternatively, this data can be rolled back by the next CLEAR_FORM.

Syntax

PROCEDURE POST;

Built-in Type    restricted procedure
Enter Query Mode  no
Parameters
none

Usage Notes
If this form was called via OPEN_FORM with the NO_SESSION parameter specified, then the POST will validate and write the data both in this form and in the calling form.

POST examples
/*
    Built-in:  POST and EXIT_FORM
    Example:   Leave the called form, without rolling back the posted changes so they may be posted and committed by the calling form as part of the same transaction.
*/
BEGIN
Post;
/*
    Form_Status should be ’QUERY’ if all records were successfully posted.
*/
IF :System.Form_Status <> ’QUERY’ THEN
Message(’An error prevented the system from postingchanges’);
RAISE Form_trigger_Failure;
END IF;
/*
    By default, Exit_Form asks to commit and performs a rollback to savepoint. We’ve already posted, so we do not need to commit, and we don’t want the posted changes to be rolled back.
*/
Exit_Form(NO_COMMIT, NO_ROLLBACK);
END;