15.3.2 Creating Page Processes

Create a page process in Page Designer.

To create a page process:

1. View the page in Page Designer.
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.

      Page Designer appears.

2. In either the Rendering or Processing tab, locate the node where the process will occur. Right-click and select Create Process.
3. Page Designer indicates what to do next. If there is an error, the Show Messages icon displays in the Page Developer toolbar.
   1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
   2. Select an error to highlight the associated attribute in the Property Editor.

      To learn more about an attribute, select the attribute in the Property Editor and click the Help tab in the central pane.

4. Identification, Name - Enter the name of the process for easy identification by developers.
5. Identification, Type - Specify which process type to execute. The Type you select determines what attributes display next.

   Consider the following examples.

   • If Identification, Type is Execute Code:
     • Identification, Type - Select Execute Code.
     • Source, Location - Select where the process executes. Select either Local Database or REST Enabled SQL.
     • Source, Language - Select the language used to execute the entered code.
     • Source, PL/SQL - Enter the PL/SQL code to be executed.
   • If Identification, Type is Invoke API:
     • Identification, Type - Select Invoke API.
     • Settings, Type - Select what process executes. Options include: PL/SQL Package, PL/SQL Procedure or Function, or REST Source.

       What displays next, depends upon the Settings, Type you select. Consider the following examples:

       If Settings, Type is PL/SQL Package:

       • Settings, Type - Select PL/SQL Package.
       • Settings, Package - Enter the case-sensitive PL/SQL package name. You can type in the name or pick from the list.
       • Settings, Procedure or Function - Enter the case-sensitive procedure or function name defined in the selected PL/SQL package. You can type in the name or pick from the list.
       If Settings, Type is PL/SQL Procedure or Function:

       • Settings, Type - Select PL/SQL Procedure or Function.
       • Settings, Procedure or Function - Enter the case-sensitive procedure or function name defined in the selected PL/SQL package. You can type in the name or pick from the list.

       If Settings, Type is REST Source:

       • Settings, Type - Select REST Source.
       • Settings, REST Source - Select the REST Source which contains the Operation to be invoked.
       • Settings, Operation - Select the Operation to invoke. The select list shows the name, if configured for the REST Operation. Otherwise, its HTTP method and URL pattern will be shown.
6. Under Execution :
   1. Execution, Sequence - Specify the sequence for this computation. The sequence determines the order of execution.

      If two components have the same sequence value, then they may be executed in a different order when the application is exported and imported into another environment.

   2. Execution, Point - Select the point at which this process is executed.
   3. Execution, Run Process - Select the frequency that this process executes.
7. Under Success Message:
   • Success Message, Success Message - Enter the success message for this process.

     If the process runs and does not generate an error, then this process success message displays in the notification section of the resulting page displayed. If you are branching to another page using a URL redirect, you may need to check the preserve success message attribute.

     To learn more, select the attribute in the Property Editor and click the Help tab in the central pane.

8. Under Error:
   1. Error, Error Message - Enter the error message for this process.

      This message displays if an unhandled exception is raised. After any error processing stops, a rollback is issued and an error message displays.

   2. Error, Display Location - Select where this process error message displays, when the process fails to complete successfully.
9. Click Save.

See Also:

• Creating Pre-Rendering Branches, Computations, and Processes
• Creating Page Submission Branches, Validations, Computations, and Processes