 |
|
Oracle Tips by Burleson |
Process Points
A Process Point defines when, during the page
rendering or page processing, the process will be considered for
execution.
Application Level Process Points
On New Instance - After Authentication: This is
an application level process and should be created as such. When
creating an application level process in the shared components
section, it is called On New Session - After Authentication. This can
be confusing as it is for an application level computation. A
technique that can be used for this type of process if the user
logging in is listed as a developer is to set an application level
item to a TRUE value. Then the application level item in the
Conditions of other page level items can be used for debugging
information.
-
Page Rendering Processes
-
The following is a listing of page rendering
processes:
-
On New Instance. After Authentication
-
On Load – Before Header
-
On Load – After Header
-
On Load – Before Regions
-
On Load – After Regions
-
On Load – Before Footer
-
On Load – After Footer
-
On Submit – Before Computations and Validations
-
On Submit – After Computations and Validations
The On New Instance and On Load will direct the
process to be considered for execution during page rendering. These
display points are commonly used for populating the page items of an
application page.
When a Form page is created using the wizard, it
will create an After Header process used to fetch the row from the
database and populate the page items. This is the process point to
choose when writing custom queries to populate page items. The Before
Header and Before Regions process point could also be used for
populating page items during page rendering.
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
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|