Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldr_pg_procs_about.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Understanding Page Processes</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:27Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Understanding Page Processes" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="bldr_pgs.htm" title="Working with Application Pages" type="text/html" /> <link rel="up" href="bldr_pg_edit.htm" title="Editing a Page Definition" type="text/html" /> <link rel="up" href="bldr_pg_procs_about.htm" title="Understanding Page Processes" type="text/html" /> <link rel="prev" href="bldr_validate.htm" title="Previous" type="text/html" /> <link rel="next" href="bldr_branches_about.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="bldr_pgs.htm" title="Working with Application Pages">Working with Application Pages</a> > <a href="bldr_pg_edit.htm" title="Editing a Page Definition">Editing a Page Definition</a> > Understanding Page Processes</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="bldr_validate.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldr_branches_about.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CJGJBJHG" name="CJGJBJHG"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB04019|page processes"></a>Understanding Page Processes</h1> <p>A page process performs an action at a specified point during the rendering or submission of the page. For example, you can create a page process to execute logic or to make a call to the Application Express engine. A page process is a unit of logic that runs when a specific event occurs, such as loading or submitting a page.</p> <p>From a functional perspective, there is no difference between page-level and application-level processes. The difference between these two process types is where the process is defined, that is at the page-level or at the application level.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="bldr_app_proc.htm#BABDCJBE">"Understanding Application Processes"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="sthref587" name="sthref587"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABEHDGA">Creating a Page Process</a></p> </li> <li> <p><a href="#BABCHDHJ">Editing Process Attributes</a></p> </li> </ul> <a id="BABEHDGA" name="BABEHDGA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25144" id="HTMDB25144"></a>Creating a Page Process<a id="sthref588" name="sthref588"></a></h2> <p>You create a process by running the <a id="sthref589" name="sthref589"></a><a id="sthref590" name="sthref590"></a>Create Process Wizard. During the wizard, you define a process name, specify a sequence and the point at which the process will execute, and select a process category. You can change nearly all of these attributes on the Edit Page Process page.</p> <p>To create a process:<a id="sthref591" name="sthref591"></a><a id="sthref592" name="sthref592"></a><a id="sthref593" name="sthref593"></a><a id="sthref594" name="sthref594"></a><a id="sthref595" name="sthref595"></a><a id="sthref596" name="sthref596"></a><a id="sthref597" name="sthref597"></a></p> <ol> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Processes, click the <span class="bold">Create</span> icon.</p> </li> <li> <p>Select a category. <a href="#CJGBJBGJ">Table: Process Categories</a> describes available page process categories.</p> <div class="tblformal"><a id="sthref598" name="sthref598"></a><a id="CJGBJBGJ" name="CJGBJBGJ"></a> <p class="titleintable">Process Categories</p> <table class="Formal" title="Process Categories" summary="This table describes the available page process categories." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t49">Process Category</th> <th align="left" valign="bottom" id="r1c2-t49">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t49" headers="r1c1-t49"> <p>Data Manipulation</p> </td> <td align="left" headers="r2c1-t49 r1c2-t49"> <p>Data Manipulation process types are frequently used by wizards to support data manipulation language (DML) actions. Application Builder supports the following declarative data manipulation processes:</p> <ul> <li> <p>Select <span class="bold">Automatic Row Fetch</span> and <span class="bold">Automatic Row Processing</span> <span class="bold">(DML)</span> to create an automatic data manipulation language (DML) process.</p> </li> <li> <p>Use <span class="bold">Multi Row Update</span> and <span class="bold">Multi Row Delete</span> with tabular forms.</p> </li> <li> <p>Use <span class="bold">Add Rows to Tabular Form</span> with a tabular form.</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t49" headers="r1c1-t49"> <p>Close Popup Window</p> </td> <td align="left" headers="r3c1-t49 r1c2-t49"> <p>Applies to processes running within a popup window. Upon execution, this process type closes the current popup window.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t49" headers="r1c1-t49"> <p>Form Pagination</p> </td> <td align="left" headers="r4c1-t49 r1c2-t49"> <p>Implements pagination through the detail records associated with a master detail form. Most often used in master detail forms (such as in the Master Detail Wizard), this process checks the master table to determine which set of detail records you are in and determines what the next detail record should be.</p> <p><span class="bold">See Also:</span> <a href="bldapp_frm_detail.htm#BCEBEDIC">"Creating a Master Detail Form"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t49" headers="r1c1-t49"> <p>On Demand</p> </td> <td align="left" headers="r5c1-t49 r1c2-t49"> <p>Creates an application-level process that can only be executed when called from a specific page. When you create this process type at the page-level, you are creating reference to an existing application-level process.</p> <p><span class="bold">See Also</span>: <a href="bldr_app_proc_ondemand.htm#BABEAIIE">"About On Demand Application Processes"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t49" headers="r1c1-t49"> <p>PL/SQL</p> </td> <td align="left" headers="r6c1-t49 r1c2-t49"> <p>Runs the PL/SQL you provide. Use this process type to execute a block of PL/SQL entered directly into the process or to simply call an existing API.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t49" headers="r1c1-t49"> <p>Reset Pagination</p> </td> <td align="left" headers="r7c1-t49 r1c2-t49"> <p>In Report regions, resets pagination back to the first result set. The Application Express engine keeps track of where the user is within a given result set. This process category returns the user to the beginning result set. In other words, this category resets the counters associated with the report region to return the first part of the result set the next time the result set displays.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t49" headers="r1c1-t49"> <p>Session State</p> </td> <td align="left" headers="r8c1-t49 r1c2-t49"> <p>Sets the values of existing session state items to null. Select this process type to clear the cache for applications, sessions, or items and to clear existing user preferences.</p> <p><span class="bold">See Also:</span> <a href="concept_ses_val.htm#BEIFIHFH">"Managing Session State Values"</a> and "Managing User Preferences" in <a href="AEADM/aadm_mg_sessions.htm"><span class="italic">Oracle Application Express Administration Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t49" headers="r1c1-t49"> <p>Web Services</p> </td> <td align="left" headers="r9c1-t49 r1c2-t49"> <p>Implements a Web Service as a process on a page. Running the process submits a request to the service provider.</p> <p><span class="bold">See Also:</span> <a href="advnc_web_invoke.htm#BABBCIIJ">"Invoking a Web Service as a Process"</a></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></li> <li> <p>Follow the on-screen instructions.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BABCHDHJ" name="BABCHDHJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25145" id="HTMDB25145"></a>Editing Process Attributes<a id="sthref599" name="sthref599"></a></h2> <p>Once you create a process, you can control when the process executes and what the process does by editing attributes on the Edit Page Process page.</p> <p>To edit an existing page process:</p> <ol> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Select the process name.</p> <p>The Edit Page Process page appears.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="concept_sub_strings.htm#CHDDCFIJ">"About the When Button Pressed Attribute"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="CHDDAFCJ" name="CHDDAFCJ"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25146" id="HTMDB25146"></a>Changing Processing Points and Source<a id="sthref600" name="sthref600"></a><a id="sthref601" name="sthref601"></a></h3> <p>You control when a process executes by specifying a sequence number and a process point under Process Point. You can prevent a process from running during subsequent visits to a page by selecting one of the following options under Run Process:</p> <ul> <li> <p>Once for each page visit</p> </li> <li> <p>Once for each session or when reset</p> </li> </ul> <p>Enter the appropriate code for PL/SQL process types. For PL/SQL anonymous block processes, enter the appropriate code under <span class="bold">Process</span>. For Clear Cache processes, enter the appropriate code under <span class="bold">Source</span>. In the event a process fails, you can optionally define an error message in the Process Error Message field.</p> </div> <!-- class="sect4" --> <a id="CHDEBBGC" name="CHDEBBGC"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25147" id="HTMDB25147"></a>Creating Conditional Processes<a id="sthref602" name="sthref602"></a></h3> <p>You can make a process conditional by selecting a condition type and entering an expression under Conditional Processing.</p> <p>Additionally, you can also make a selection from the When Button Pressed attribute. When you select a button from this list, the process only executes if a user clicks the selected button.</p> </div> <!-- class="sect4" --></div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="bldr_validate.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldr_branches_about.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de