- App Builder User's Guide
- Managing Computations, Validations, and Processes
- Understanding Page Processes
- Creating Page Processes
15.3.2 Creating Page Processes
Create a page process in Page Designer.
To create a page process:
- View the page in Page Designer.
- On the Workspace home page, click the App Builder icon.
- Select an application.
- Select a page.
Page Designer appears.
- In either the Rendering or Processing tab, locate the node where the process will occur. Right-click and select Create Process.
- Page Designer indicates what to do next. If there is an error, the Show
Messages icon displays in the Page Developer toolbar.
- Click the Show Messages icon on the Page
Designer toolbar.The Messages dialog displays errors that must be addressed.
- 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.
- Click the Show Messages icon on the Page
Designer toolbar.
- Identification, Name - Enter the name of the process for easy identification by developers.
- 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.
- If Identification, Type is Execute
Code:
- Under Execution :
- 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.
- Execution, Point - Select the point at which this process is executed.
- Execution, Run Process - Select the frequency that this process executes.
- Execution, Sequence - Specify the sequence for this computation. The
sequence determines the order of execution.
- 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.
- Success Message, Success Message - Enter the success message for this
process.
- Under Error:
- 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.
- Error, Display Location - Select where this process error message displays, when the process fails to complete successfully.
- Error, Error Message - Enter the error message for this process.
- Click Save.
Parent topic: Understanding Page Processes