Home | Articles | Oracle Forms | Built In Routines | POST built-in Oracle Forms

POST built-in Oracle Forms

Font size: Decrease font Enlarge font

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.



Built-in Type    restricted procedure
Enter Query Mode  no

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.
    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;
    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.

Subscribe to comments feed Comments (2 posted)

ali 13/03/2018 20:32:27
good post
dissertation writing help 13/03/2018 21:42:48
Mostly official workers use the computer for keep the data in the computer. Its common thing but hackers can hack our in easily. So we should downlaod before the privacy system for it.
total: 2 | displaying: 1 - 2

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article