Page History
...
The JITL PLSQLJob provides a parameterizable interface for executing Oracle® PL/SQL statements. The JS7 offers out-of-the-box capabilities
- to execute PL/SQL,
- to pass arguments to PL/SQL
- to collect and to pass on the results of PL/SQL execution to a next jobjobs.
The PLSQLJob can be used to execute files that include PL/SQL statements.
Usage
When defining the job consider
- to select the JITL job class and
- to specify the
com.sos.jitl.jobs.db.oracle.PLSQLJobJava class name.
The following example shows a basic example of the PLSQLJob. It executes PL/SQL anonymous code blocks - selecting the current system date and writing it to stdout.
...
Overview
Content Tools