 |
|
Oracle Tips by Burleson |
Page Rendering Process
So far, a button and a branch to navigate to the
reusable application page have been created. The page item,
P100_SEARCH, has been set to a value of Find Person. At this point,
we have navigated to the reusable page and are awaiting its return.
When the page returns, it will set the application item G_PERSON_ID to
the person_id found while searching.
Now, the value in G_PERSON_ID will be used to
populate the person data page items.
When finished, there should be two Before Regions
processes, as shown in Figure 16.8.
The Set Person Id process source is shown in
Figure 16.9. This process must be executed before the Populate
process because the Populate process depends on the value set in the
Set Person Id process.
The Set Person Id process is checking the
P100_SEARCH page item. At this point, it will be set to Find Person
and set the P100_PERSON_ID to the value returned by the reusable
application page.
The Populate process is also a Before Regions
process, but it has a higher sequence than the Set Person Id process.
Thus, HTML DB will execute the Populate process after the Set Person
Id process.
The Populate process, shown in Figure 16.10, takes
the key value in the P100_PERSON_ID page item and uses it to query the
person data from the database.
This same process could be used to populate
several page items on a single page. An example would be page items
for an employee and page items for the person’s manager. Providing
another button to search for the manager and the other page components
discussed, the same application page could be reused to search for the
manager.
The
above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create Dynamic
Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
