Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • to execute PL/SQL,
  • to pass arguments to PL/SQL
  • to collect and to pass on the results of a PL/SQL execution to a next job.  

...

The job automatically creates the following order variables that are available to subsequent instructions and jobs. 

Return Variable: sql_error

  • The sql_error order variable contains the error messages generated during PL/SQL execution. This variable will be empty if no errors occur.

Return Variable: std_out_output

  • The std_out_output order variable contains the messages spooled to stdout by PL/SQL. 

...