Monday, 14 March 2016

Oracle Forms Debugging: Using the “DEBUG_MESSAGES=YES” runtime option - Handling "Please Acknowledge" message

Oracle Forms Debugging: Using the “DEBUG_MESSAGES=YES” runtime option - Handling "Please Acknowledge" message

“DEBUG_MESSAGES=YES” is a “quick and dirty” technique for pinpointing code problems. This causes a message to automatically display to let you know each trigger as it executes. Once you encounter the runtime error, you will know the last trigger that fired and should be able to trace through the code from that point. For anyone that was around in the SQL*Forms 3.0 days, this was the default behavior when running a form in debug mode.

To use this option from the Form Builder, check the “debug_messages” option on the runtime tab after choosing Tools -> preferences from the menu. From the command line, simply add the “debug_messages=yes” option. 

If you are using an icon in Windows to start your form, add the option to the shortcut command. It would look something like this for Windows platforms:

c:\orant\bin\ifrun60.exe module=myform userid=scott/tiger debug_messages=yes

On Unix:
f60runm module=myform userid=scott/tiger debug_messages=yes

The major disadvantage of using this technique is that you have to acknowledge every message as each trigger executes, which can be very annoying. You will keep getting "Please acknowledge message" prompt each time whenever a new trigger is encountered. Although it shows the triggers that fire, it does not show program units that execute, and there is no way to display the values of variables. It can also cause the same focus problems and program flow interruption that you see with the “MESSAGE” built-in. However, this method is useful if you have no idea which trigger is causing the problem; once you have narrowed down the scope, other troubleshooting techniques would be more appropriate.

30 comments:

  1. There are lots of information about latest technology and how to get trained in them, like this have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies. By the way you are running a great blog. Thanks for sharing this.
    SEO training in chennai

    ReplyDelete
  2. Unsere ersten Worte sollten an Kunden wärmsten Grüße verschickt werden!in kỷ yếu giá rẻ
    in phong bì giá rẻ

    Aktien der Gesellschaft in Hong Dang seit 2006,mẫu thẻ nhân viên đẹp
    In thẻ VIP giá rẻ nach mehr als 10 Jahren der Entwicklung sind wir stolz,mau ky yeu dep
    mau phong bi dep die obere Einheit im Bereich der Gestaltung,báo giá in kẹp file
    in giấy khen Druck und Werbung in Hanoi zu sein. Im Laufe der Jahre hat sich unser Unternehmen steigen ständig bemüht,in bao li xi
    in thiep chuc mung nam moi
    in catalogue viele Schwierigkeiten aus dem harten Wettbewerb des Marktes zu überwinden, der Anstieg der Inputpreise für Rohstoffe, .... den Preis und Qualität der Ware erhalten. Die Produkte in immer besser, professioneller. Das ist im Design, Druckvorstufe, Druck und Verarbeitung von Fertigprodukten


    ReplyDelete
  3. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.

    SEO Company in Chennai

    ReplyDelete
  4. Best Fake ID Website Buy a Fake ID today that scans and has working hologram. Not only that, but passes blacklight test! We got plenty of Fake ID Reviews for you to view.


    ReplyDelete
  5. It’s really amazing that we can record what our visitors do on our site. Thanks for sharing this awesome guide. I’m happy that I came across with your site this article is on point,thanks again and have a great day. Keep update more information..

    Digital marketing company in Chennai

    ReplyDelete
  6. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.


    SAP Training in Chennai

    ReplyDelete
  7. This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds and need to be patiently wait till it blossoms.

    Corporate Training in Chennai

    ReplyDelete
  8. I am expecting more interesting topics from you. And this was nice content and definitely it will be useful for many people.

    Digital Marketing For Small Business in Chennai

    ReplyDelete
  9. Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting.So know it's helpful.

    PPC Services in Chennai

    ReplyDelete
  10. this is really a very great blog. the information present in this blog will be very useful for us. thank you for sharing with us.
    ROI Services in Chennai

    ReplyDelete
  11. These information really worth saying, i think you are master of the content and thank you so much sharing that valuable information and get new skills after refer that post.


    Content marketing services in chennai

    ReplyDelete

  12. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks..!


    Online Reputation Management

    ReplyDelete
  13. This blog explains the details of most popular technological details. This helps to learn about what are all the different method is there. And the working methods all of that are explained here. Informative blog.
    Digital Marketing Company in Chennai

    ReplyDelete
  14. Superb. I really enjoyed very much with this article here. Really its an amazing article that i have ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your updation.
    Software Testing Training

    ReplyDelete
  15. thanks for shared wonderful information of giving best information.its more useful and more helpful. great doing keep sharing
    Sharepoint Training

    ReplyDelete
  16. I have been following you for a couple of months now but this is my first time commenting on a blog post. Thank you for sharing your knowledge and experience with us. Keep up the good work. Already bookmarked for future reference.
    Hadoop Training in Chennai
    Hadoop Training
    Best Hadoop Training in Chennai
    Best Hadoop Training Institute in Chennai

    ReplyDelete
  17. I have definitely picked up anything new from right here. I did however expertise a few technical points using this site, since I experienced to reload the web site a lot of times previous to I could get it to load correctly.

    Best Sharepoint Training Institute in Chennai

    ReplyDelete
  18. thus your information are really nice and very much implementive and useful too. it is really awesome and very much exclusive too.Thanks for sharing those valuable information.

    Best Sharepoint Training Institute in Chennai

    ReplyDelete
  19. Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
    seo company in india
    digital marketing company in india
    seo company in chennai
    digital marketing company in chennai

    ReplyDelete
  20. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.

    seo company in india

    ReplyDelete
  21. I just see the post i am so happy to the communication science post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be replay for your great thinks and I hope you post again soon.

    Software Testing Training Institute in Chennai

    ReplyDelete
  22. The blog is absolutely truly incredible. Lots of large information and inspiration, both of which we all need.


    Bangalore Web Designing Company, Web Development Company Bangalore

    ReplyDelete
  23. Excellent and very cool idea and the subject at the top of magnificence and I am happy to this post..Interesting post! Thanks for writing it. What's wrong with this kind of post exactly? It follows your previous guideline for post length as well as clarity..

    Best Dental Clinic In Chennai

    Best Dental Clinic In Tambaram

    ReplyDelete
  24. I am regular visitor of this blog .I am working as blog reviewer in a private press and I saw many useful posts here. Sure, I will give best ratings for this blog .Keep posting best posts like this to get top reviews and ratings from blog reviewers and people .And I am thankful for this valuable post.
    Engineering Colleges in Chennai | Mechanical Colleges in Chennai | ECE Colleges in Chennai

    ReplyDelete
  25. I just keep visiting this blog from past two years. The posts here are unique and useful than other blog posts. Such a great info provided in this post. Keep providing useful post in this blog .I appreciate author for this valuable post. Culinary Schools in Dubai | International Centre for Culinary Arts

    ReplyDelete
  26. It was a great information and Its really worth reading it. The author did an mind blowing work by describing each and every concept in detail. Thanks for such an informative post. Please keep up your good work.
    ECE Colleges in Chennai

    ReplyDelete