PL/SQL API jcs.output_parameter
Summary
Returns the value of an output parameter.
The return value is always a string. Numbers are formatted in 'natural' formatting, and dates in the standard date format.
Parameters that have the OUT attribute can change value when the job goes from RUNNING to COMPLETED.
Specification
function output_parameter(job_id in number,
parameter_name in varchar2)
return varchar2
Parameters
- job_id - the ID of the job
- parameter_name - the name of the parameter
- returns varchar2 - current value of the parameter for 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
See Also
plsqlTopic
onsiteTopic