Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  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

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.