Difference between call_form, new_form and open_form

5 February 2007 at 20:01 CET | In Features and tips, Forms, Oracle |

I never seem able to remember the difference between new-form, open_form and call_form. I’m just writing down the definitions from the online help in this article for my own (and perhaps others) reference:

CALL_FORM

Runs an indicated form while keeping the parent form active. Oracle Forms runs the called form with the same Runform preferences as the parent form. When the called form is exited Oracle Forms processing resumes in the calling form at the point from which you initiated the call to CALL_FORM.

CALL_FORM can be instructed to hide or not hide the calling form, replace or not replace the menu, open the new form in query only mode, share or not share library data.

NEW_FORM

Exits the current form and enters the indicated form. The calling form is terminated as the parent form. If the calling form had been called by a higher form, Oracle Forms keeps the higher call active and treats it as a call to the new form. Oracle Forms releases memory (such as database cursors) that the terminated form was using.

Oracle Forms runs the new form with the same Runform options as the parent form. If the parent form was a called form, Oracle Forms runs the new form with the same options as the parent form.

NEW_FORM can be instructed to continue the database transaction, rollback to the current savepoint or perform a full rollack. It can also be instructed to open the new form in query only mode and to share or not share library data.

OPEN_FORM

Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time.

OPEN_FORM can be instructed for the two forms to share the same database session and/or library data.

27 Comments

TrackBack URI

  1. Does any one have idea how to achieve cross platform database replication. We have database on WIndows NT server and would like to replicate the same online or in batch at end of day on UNix server as a part of DR

    Comment by Manoj — 8 February 2007 #

  2. I’m not a DBA so I might very well not know all possibilities. But transportable tablespaces cannot be used since one platform is little-endian and one big-endian. I expect that DataGuard won’t work either with different platforms, especially with a different endianness.

    The only thing I can think of is a full export and import using expdp/impdp. But for DR I would always go with two (mostly) similar machines and not different platforms. Are you absolutely sure that everything else will work as before on a different platform?

    Comment by wilfred — 8 February 2007 #

  3. diffrence between folder authentication and open authentication

    Comment by evans — 13 March 2007 #

  4. If you wanted to have multiple forms open, but when you press a “save” button on one form, it only saves the data you have put on that one form, how would you implement that? would you use, OPEN_FORM or CALL_FORM.
    because when i press save, oracle tries to save every form that is open, it tries to save every form that is open, so i get 2 messages…

    Comment by Team4 — 25 February 2008 #

  5. I don’t think it can be done. By default, Oracle Forms uses a single database connection and thus a single database transaction. If Form A starts a transaction, makes some modifications to the database and then starts Form B, the new Form continues on the same database transaction. If it issues a commit it will commit the entire database transaction including the changes of Form A.

    Comment by wilfred — 29 February 2008 #

  6. Discover the best penis enlargement products, that reviews by best penis enlargement consumer review result to get the best penis enlargement products that really works. get the real penis enlargement truth at http://www.penis4enlargement.com

    Comment by penis enlargement — 13 July 2009 #

  7. I really liked your blog. Very useful information, I read it detail, also book-marked it and will be back in the future to read some more of your interesting posts ! keep up the good work. My site is http://www.pennisenlargementproducts.com/

    Comment by penis enlargement — 16 July 2009 #

  8. More info Penis-Health :www.male-sexual-styles.com penis enlargement products, penis enlargement pills

    Comment by penis enlargement — 27 July 2009 #

  9. great job

    Comment by penis enlargement — 10 August 2009 #

  10. Male Enhancement Pills are a natural herbal supplement and have not been shown to have any serious side effects. If you have any medical concerns you may review the ingredients with your doctor or healthcare professional.

    Male Enhancement Pills are an ingestible supplement; the results you see are permanent as long as you continue to take the recommended dosage. Once desired results are achieved, some men scale back dosage to a maintenance amount of one capsule three or four times a week. This reduction in dosage should not compromise erection size or fullness, once desired results have been achieved.

    Click Here To ORDER VigRX Plus Pills

    http://www.vigrxplus.com/?a=bestpenisenlargement

    http://www.vigrxplus.com/?a=bestpenisenlargement

    more information:
    http://www.penisenlargement4male.com
    http://www.4-penisenlargement.com

    Comment by penis enlargement — 13 August 2009 #

  11. Hair Loss Treatments - Products Cures and Solutions Guide. Read the Hair Loss Guide - Know about Causes, Treatments, Solutions and hairstyles for Men and Women at http://www.Managehairloss.com

    Comment by Hair loss — 14 August 2009 #

  12. hi every one .. I want to know some thing. Which is that how to increases our own website pr . My site is that http://www.penisenlargementy.com

    Comment by Natural Penis Enlargement — 19 August 2009 #

  13. Penis Enlargement ; The top-rated penis enlargement device. Penis enlargement science easy fast and safe penis enlargement at http://www.penissizeenlargement.net

    Comment by Natural Penis Enlargement — 21 August 2009 #

  14. Vigrx is a natural herbal formula for penis enhancement that works to increase penis size, improve sexual health and strengthen erections when you are aroused, buy it now at http://www.vigrxpillz.com

    Comment by Vigrx — 24 August 2009 #

  15. penis enlargement products to enlarge penis size in natural way by using best herbal ingredients penis enlargement pills selling at http://www.naturalherbalz.com

    Comment by penis enlargement — 30 August 2009 #

  16. Cheap Penis enlargement, Male enhancement, premature ejaculation and erectile dysfunction products and treatments at http://www.gordoniihoodia.net

    Comment by male enlargement — 2 September 2009 #

  17. Penis enlargement by Naturalherbalz will improve every aspect of your life immensely. As long as you make use of all the resources available to your through this site, your visit here will not be in vain. We offer you the best penis enlargement methods you can attain on the market today at http://www.Naturalherbalz.com

    Comment by Penis enlargement — 7 September 2009 #

  18. We are offering best natural herbal ingrdient made penis enlargement and male enhancement products for erectile dysfunction, sexual drive and bigger penis size with hard rock erections at http://www.penisenlargementmedicine.com

    Comment by penis enlargement — 12 September 2009 #

  19. Want to get bigger penis size in few weeks without any side effects? Get best penis enlargement products that enlarge penis size naturally at http://www.penis4enlargement.com

    Comment by Bigger penis — 15 September 2009 #

  20. does vimax work? First interesting post in a while.

    Comment by vimax — 27 September 2009 #

  21. vigrx plus male enhancement pills

    Comment by vigrx plus — 27 September 2009 #

  22. prosolution pills male enhancement products

    Comment by prosolution pills — 27 September 2009 #

  23. This is one of the best blog i have just seen, i am really feeling honor and pleasure that i am able to post my views here in this blog, a really appreciatable work done by webmaster of this blog. Going great man! keep it up. http://www.viagra-viagra.com

    Comment by Viva Viagra — 6 October 2009 #

  24. nice blog!!!
    n,n
    excellent

    Comment by katie — 6 October 2009 #

  25. It’s really great to post my comments on such a blog. I would like to appreciate the great work done by the web master and would like to tell everyone that they should post their interesting comments and should make this blog interesting.

    Comment by enlarge Penis — 8 October 2009 #

  26. Nice blog, its great article informative post, thanks for sharing it. Thanks for the information!

    Comment by santana — 31 October 2009 #

  27. Discover the real facts about penis enlargement pills, devices, patches and exercises. Find out how to enlarge your penis fast & effectively.
    http://penis-enlargement-online.org
    http://maleenhancement-pills.com
    http://www.pills4enlaargement.com

    Comment by penis enlargement — 3 November 2009 #

Trackback/Pingbacks:

  1. Penis Enlargement Pill Myths | Free Enzyte

    [...] OraTransplant » Difference between call_form, new_form and open_form – Difference between call_form, new_form and open_form. 5 February 2007 at 20:01 CET | In Features and tips, Forms, Oracle |. I never seem able to remember the difference between new-form, open_form and call_form. … [...]

Sorry, the comment form is closed at this time.

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds.