...
This article describes how to launch an Oracle™ RDBMS stored procedure using the JITL Job JobSchedulerPLSQLJob. This job is used standalone or triggered by orders to execute pl/sql statements in a database. These can be stored procedures or SQL statements as well.
The example also shows, how to send the result (output) of an pl/sql job as an email.
...
The SQL commands are defined using the command parameter.
It is possible to define more than one command as value of the command parameter.
Such commands are then carried out in the order in which they are written and must be separated by a semicolon and a subsequent new line.
You can have to use the character sequence as for a newline.
Example of a stored procedure:
...