PL/SQL API jcs.return_code

Summary

• function return_code(job_id in number) return number

Return the numerical value returned by the job when it finished or was killed.

In most scripting languages, this is set by 'exit '.

The exact numerical values returned are operating system and job dependent.

Specification

function return_code(job_id in number)
    return number

Parameters

• job_id - the ID of the job
• returns number - value returned by the job

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Examples

Using jcs.return_code
      ...
       jcs.submit(...);
       commit;
       jcs.wait(...);
       if jcs.job_statuscode(jcs.last_job_id) <> 'C'
       then
         jcs_out.put_line('Job terminated with error: '
                          || jcs.return_code(jcs.last_job_id);
       end if;
      ...

Using jcs.return_code

plsqlTopic

onsiteTopic