PL/SQL API jcs.set_job_format

Summary

• procedure set_job_format(script in varchar2, format in varchar2, format_partition in varchar2)

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

Specification

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

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

• jcs.submit
• jcs.run

plsqlTopic

onsiteTopic