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

POST built-in Oracle Forms

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

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;

Subscribe to comments feed Comments (12 posted)

avatar
ali 13/03/2018 20:32:27
good post
avatar
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.
avatar
petterson 03/07/2018 16:30:56
Good to become visiting your weblog again, it has been months for me. Nicely this article that i've been waited for so long. I will need this post to the total of my assignment in the college, and it has the exact same topic together with your write-up. Thanks, good share.
avatar
Black Friday Sales 13/08/2018 17:37:00
Generally official laborers utilize the PC for keep the information in the PC. Its regular thing however programmers can hack our in effortlessly. In PC we have to the numerous data and programming. Its accommodating and helpful to do anything on it. Here is best post about it and we should read it since it better approach to know everything going to know about PC training.
avatar
Cranberry 27/08/2018 15:30:24
This is an awesome motivating article.I am practically satisfied with your great work.You put truly extremely supportive data. Keep it up. Continue blogging. Hoping to perusing your next post
avatar
Cranberry Juice 27/08/2018 15:53:38
I was taking a gander at some of your posts on this site and I consider this site is truly informational! Keep setting up..
avatar
Tomatillos 27/08/2018 15:58:55
I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.
avatar
Garcinia Cambogia 27/08/2018 16:04:24
It's really nice and meanful. it's really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information.
avatar
Cowpeas 27/08/2018 16:05:01
I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day!
avatar
Green Tea 27/08/2018 16:29:37
I am always searching online for articles that can help me. There is obviously a lot to know about this. I think you made some good points in Features also. Keep working, great job
1 2 next total: 12 | displaying: 1 - 10

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

Captcha
  • 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

0