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:
Creating an executable.
Creating a concurrent program.
Attaching parameters to concurrent programs if needed.
Attaching concurrent programs to a request group.
Running a program.
Viewing the output and log.
Scheduling a program if needed.
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...