jcs.parameter

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

Summary

Specification

Copy 
procedure parameter(object_name in varchar2,
parameter_name in varchar2,
value in timestamp with time zone)

Set a timestamp parameter.

Parameters

  • object_name - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • parameter_name - parameter name
  • value - the value to set the parameter tofs

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 submit_buffer

Specification

Copy 
procedure parameter(object_name in varchar2,
parameter_name in varchar2,
value in date)

Set a date parameter.

Parameters

  • object_name - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • parameter_name - parameter name
  • value - the value to set the parameter to

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

Specification

Copy 
procedure parameter(object_name in varchar2,
parameter_name in varchar2,
value in varchar2)

Set a string parameter.

Parameters

  • object_name - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • parameter_name - parameter name
  • value - the value to set the parameter to

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

Specification

Copy 
procedure parameter(object_name in varchar2,
parameter_name in varchar2,
value in number)

Set a number parameter.

If a number parameter value is passed that has a greater scale than the script allows, it is silently rounded to the scale specified in the script. For example, trying to set a script parameter NUMBER(4,2) to 12.3456 results in it being set to 12.35. A subsequent function call jcs.parameter will return 12.35.

Parameters

  • object_name - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • parameter_name - parameter name
  • value - the value to set the parameter to

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

Specification

Copy 
procedure parameter(object_name in varchar2,
parameter_name in varchar2,
value in varchar2,
format in varchar2)

Set a string, date or number parameter that is formatted according to the supplied format.

Parameters

  • object_name - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • parameter_name - parameter name
  • value - the value to set the parameter to
  • format - the input format to apply

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

Specification

Copy 
function parameter(object_name in varchar2,
parameter_name in varchar2)
    return varchar2

The jcs.parameter function returns the last parameter value that has been set for the given parameter, or the default value if jcs.parameter has not been called for that parameter.

Note: If the parameter is a date, it is always returned in the standard datetime format ('SYYYYMMDDHH24MISS').

Parameters

  • object_name - object name (script_name or owner.script_name), possibly with double quotes to specify lower case identifiers
  • parameter_name - parameter name
  • returns varchar2 - current parameter value