Standard Request Submission

Standard Request Submission (SRS) gives you control over how you run your requests and request sets in an application. The following are the steps involved in SRS:

1. Creating an executable.
2. Creating a concurrent program.
3. Attaching parameters to concurrent programs if needed.
4. Attaching concurrent programs to a request group.
5. Running a program.
6. Viewing the output and log.
7. Scheduling a program if needed.

Creating an executable

An executable actually holds the location of the logic of the concurrent program.

Navigate to System Administrator | Concurrent | Program | Executable:

The important field is Execution Method, which describes the type of method used in a concurrent program. The various methods used are as shown in the screenshot:

If you want your concurrent program to run the PL/SQL block, then select PL/SQL Stored Procedure as the execution method.

The format of the execution filename I have used is package.procedure. When you submit the concurrent program, the application...