CS/IT Tutorials Collections

How to Create Pop Up Menus in Oracle Forms ?

Pinterest LinkedIn Tumblr
Pop Up menus are those, which are displayed on the screen when we right click on it. Pop Up menu makes any application easier to use it. In Oracle Forms also we can make pop up menus to add different menu items for the operating form.  The items for operations such as inserting, saving, deleting and navigating records can be included in the pop up menu. Here I have written some steps for creating pop up menus in Oracle Forms along with their screenshots.
Pop Up Menus in Oracle Forms

Steps for Creating Pop Up Menus 

1. At first create a form as the post “How to Create Oracle Forms by Using Wizard ?”  .  Click on Pop Up option in object navigator, Click on plus + sign and rename the menu name. Right click on menu name and click on Menu Editor. Add the new items by clicking on plus down and plus right buttons as given below.

Menu Editor for Pop Up Menus in Oracle Forms

2. Add the items as given in the image below.

Menu Editor for Pop Up Menus in Oracle Forms

3. Right click on menu items on the object navigator and click on PL/SQL Editor option. Write PL/SQL queries On the PL/SQL Editor window as given below.

PL/SQL Editor for Pop Up Menus in Oracle Forms
4. Add the following PL/SQL queries in the PL/SQL editor for respected items.

  • PREVIOUS:           previous_record;
  • NEXT:                  next_record;
  • FIRST:                  first_record;
  • LAST:                   last_record;
  • INSERT:               create_query;
  • CONDITION:        enter_query;
  • SAVE:                  commit;
  • DELETE:              delete_record;
  • EXIT:                  exit_form;

5. For adding Menu Item Type as Separator, go to Property Palette by right clicking on menu item and clicking on Property Palette option. Select Separator on Menu Item Type property under Functional property.

Property Palette for Pop Up Menus in Oracle Forms

6. For assigning Pop Up menu on the form, right click on canvas and click on Property Palette option. From Popup Menu option under Functional property select the Popup Menu name as in the image below.

Property Palette for Pop Up Menus in Oracle Forms

7. Save, Compile and Run the form. You can view the Popup menu while right clicking on form area.

Author

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 8 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.

Comments are closed.