jcs.set_job_format

on-site-related topic PL/SQL API jcs.set_job_format

Summary

Set the format of job that is to be submitted to a different format than originally defined at script level.

Specification

Copy 
procedure set_job_format(script in varchar2,
format in varchar2,
format_partition in varchar2 default null)

Parameters

  • script - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • format - The name of the required format
  • format_partition - The Partition of the required format If it is not filled in the default Partition is assumed

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.

submit_buffer

Examples

Copy 
Using jcs.set_job_format
       begin
         host('ls -l'); commit; -- Text format is fine for ls
         jcs.parameter('HOST', 'CMD', 'cat index.html');
         jcs.set_job_format('HOST', 'HTML'); -- Override format, and thus
                                             -- extension and mimetype
         jcs.submit('HOST');
         commit;
       end;

Using jcs.set_job_format

See Also