SqlOutParamDetails

class oci.stack_monitoring.models.SqlOutParamDetails(**kwargs)

Bases: object

Position and SQL Type of PL/SQL OUT parameter

Attributes:

OUT_PARAM_TYPE_ARRAY

A constant which can be used with the out_param_type property of a SqlOutParamDetails.

OUT_PARAM_TYPE_NO_OUT_PARAM

A constant which can be used with the out_param_type property of a SqlOutParamDetails.

OUT_PARAM_TYPE_SQL_CURSOR

A constant which can be used with the out_param_type property of a SqlOutParamDetails.

out_param_name

Gets the out_param_name of this SqlOutParamDetails.

out_param_position

[Required] Gets the out_param_position of this SqlOutParamDetails.

out_param_type

[Required] Gets the out_param_type of this SqlOutParamDetails.

Methods:

__init__(**kwargs)

Initializes a new SqlOutParamDetails object with values from keyword arguments.

OUT_PARAM_TYPE_ARRAY = 'ARRAY'

A constant which can be used with the out_param_type property of a SqlOutParamDetails. This constant has a value of “ARRAY”

OUT_PARAM_TYPE_NO_OUT_PARAM = 'NO_OUT_PARAM'

A constant which can be used with the out_param_type property of a SqlOutParamDetails. This constant has a value of “NO_OUT_PARAM”

OUT_PARAM_TYPE_SQL_CURSOR = 'SQL_CURSOR'

A constant which can be used with the out_param_type property of a SqlOutParamDetails. This constant has a value of “SQL_CURSOR”

__init__(**kwargs)

Initializes a new SqlOutParamDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • out_param_position (int) – The value to assign to the out_param_position property of this SqlOutParamDetails.

  • out_param_type (str) – The value to assign to the out_param_type property of this SqlOutParamDetails. Allowed values for this property are: “SQL_CURSOR”, “ARRAY”, “NO_OUT_PARAM”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • out_param_name (str) – The value to assign to the out_param_name property of this SqlOutParamDetails.

property out_param_name

Gets the out_param_name of this SqlOutParamDetails. Name of the Out Parameter

Returns

The out_param_name of this SqlOutParamDetails.

Return type

str

property out_param_position

[Required] Gets the out_param_position of this SqlOutParamDetails. Position of PL/SQL procedure OUT parameter. The value of this property is ignored during update, if “outParamType” is set to NO_OUT_PARAM value.

Returns

The out_param_position of this SqlOutParamDetails.

Return type

int

property out_param_type

[Required] Gets the out_param_type of this SqlOutParamDetails. SQL Type of PL/SQL procedure OUT parameter. During the update, to completely remove the out parameter, use the value NO_OUT_PARAM. In that case, the value of “outParamPosition” will be ignored.

Allowed values for this property are: “SQL_CURSOR”, “ARRAY”, “NO_OUT_PARAM”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The out_param_type of this SqlOutParamDetails.

Return type

str