Adding a concurrent program parameter
In this recipe, we are going to add a parameter to the concurrent program XXHR First Concurrent Program. Parameters allow the users to pass values into the concurrent program. This can be used by the executable to impact the way it performs the intended task. We are going to add the parameter to the PL/SQL package and then change the return code based upon the value we pass in.
We will be adding a parameter to the concurrent program we have already created. We will also need to add the parameter to the code in the
XXHREEBS package and we will use SQL Developer to make these changes. The following tasks will be performed in this recipe:
- Adding a parameter to the concurrent program
- Amend the
XXHREEBSpackage to ...