Oracle Designer Tutorial |
The Oracle Web PL/SQL Generator creates fully functional web applications that enable users to query, update, delete and enter information in an Oracle database over the world wide web. In this lesson, you learn how to generate basic web applications.
Note: You can follow this lesson only if Oracle's Web PL/SQL Generator has been installed and a web server is available. You will need a username, password and connect string for the web server, and these may be different to those you have been using for the previous lessons. You will also need to know the full path of a web browser executable and the web agent URL. Your System Administrator will be able to tell you these if Web PL/SQL Generator has been set up.
In lesson 1 you created a process step called "Add new product to the menu". You progressed this process step as part of the Speedy Pizza system and implemented it as a form. In this lesson, you will implement the same process as a web application.
To implement part of the Speedy Pizza system as a web application.
This opens the Generate Table API dialog.
The Design Editor message window is opened, through which progress is reported.
Priced_Products (Base table) | Products (Lookup table) |
PP_ID | DISCOUNT_DAY |
PRODUCT_DESCRIPTION | |
PRODUCT_ID | |
PRODUCT_TYPE |
Progress is reported in the message window.
Your browser executable is opened and the generated application is shown.
The first page of the web application is a query form. Click the New button to move to the "add new product to menu" functionality (the Priced Products page).
Just as with the Forms application, the first field you fill in is Product Id. This is the identity of the product (e.g., 1011 for a Seafood Special pizza) that forms the basis of the new menu item.
Enter one of the active Product Ids in the List Of Values table to add it to the Priced Products page. Fill in the other fields to describe the new menu item, then click the Insert button to create the record.
In this lesson you created module TUTORI0060 and implemented it as a web application.
|
|