Executing a SQL Script from the SQL Scripts Page

To execute a script from the SQL Scripts page:

  1. On the Workspace home page, click SQL Workshop and then SQL Scripts.

    The SQL Scripts page appears.

  2. From the View list, select Details and click Go.

    Details view appears.

  3. Click the Run icon for the script you want to execute. The Run icon is located on the far right side adjacent to the script name.

  4. 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 to return 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. Run Now is not available for scripts with errors.

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

    The Manage Script Results page appears listing available results for the script.

  6. Click the View icon for the results you want to view. The View icon is at the right end of the scripts listed in the Manage Script Results page.

See Also:

"Viewing SQL Script Results", "Executing a SQL Script in the Script Editor", and "About the Run Script Page"