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.

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

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

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