This content has been marked as final. Show 2 replies
Firstly this isn't really in the right forum as it is standard PL/SQL but that is just for future reference. In response
1. Just read the doc - there are lots of examples of this e.g. http://docs.oracle.com/cd/E11882_01/server.112/e25494/appendix_a002.htm#ADMIN12511
2. This is basic pl/sql, again I suggest you read the documentation about how input parameters work, try this to start with: http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/subprograms.htm#i23202
I can find examples but i want an example which have job_action and number_of_arguments in it, i didnt find any examples like that.