Executing a SQL Script in the Script Editor

To execute a script in the Script Editor:

1. Open the script you want to execute in the Script Editor. See "Using the Script Editor".

2. Click Run in the Script Editor.

3. The Run Script page appears.

   The Run Script page displays information about the script and lists statements in error preventing execution, or statements such as SQL*Plus commands that are ignored when the script is executed.

   The Run Script page has three controls:

   • Cancel returns you to the SQL Scripts page without executing the script.

   • Run in Batch runs the job utilizing DDBMS_JOB rather than directly from Oracle Application Express.

   • Run Now to submit the script for execution.

4. Click Run Now to submit the script for execution.

   The Manage Script Results page appears listing script results.

5. To view script results, click the View icon under View Results.