ExecuteSqlResponseItemScript¶

class oci.database_tools_runtime.models.ExecuteSqlResponseItemScript(**kwargs)¶

Bases: object

A statement execution response for script type requests.

Attributes

`STATEMENT_TYPE_DDL`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_DML`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_IGNORE`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_JDBC`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_OTHER`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_PLSQL`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_QUERY`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_SESSION_CONTROL`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_SQLPLUS`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_SYSTEM_CONTROL`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`STATEMENT_TYPE_TRANSACTION_CONTROL`	A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
`binds`	Gets the binds of this ExecuteSqlResponseItemScript.
`dbms_output`	Gets the dbms_output of this ExecuteSqlResponseItemScript.
`error`	Gets the error of this ExecuteSqlResponseItemScript.
`properties`	Gets the properties of this ExecuteSqlResponseItemScript.
`responses`	Gets the responses of this ExecuteSqlResponseItemScript.
`result_set`	Gets the result_set of this ExecuteSqlResponseItemScript.
`result_set_object`	Gets the result_set_object of this ExecuteSqlResponseItemScript.
`results`	Gets the results of this ExecuteSqlResponseItemScript.
`statement_id`	Gets the statement_id of this ExecuteSqlResponseItemScript.
`statement_pos`	Gets the statement_pos of this ExecuteSqlResponseItemScript.
`statement_text`	Gets the statement_text of this ExecuteSqlResponseItemScript.
`statement_type`	Gets the statement_type of this ExecuteSqlResponseItemScript.

Methods

__init__(**kwargs) Initializes a new ExecuteSqlResponseItemScript object with values from keyword arguments.

STATEMENT_TYPE_DDL = 'DDL'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “DDL”

STATEMENT_TYPE_DML = 'DML'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “DML”

STATEMENT_TYPE_IGNORE = 'IGNORE'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “IGNORE”

STATEMENT_TYPE_JDBC = 'JDBC'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “JDBC”

STATEMENT_TYPE_OTHER = 'OTHER'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “OTHER”

STATEMENT_TYPE_PLSQL = 'PLSQL'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “PLSQL”

STATEMENT_TYPE_QUERY = 'QUERY'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “QUERY”

STATEMENT_TYPE_SESSION_CONTROL = 'SESSION_CONTROL'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “SESSION_CONTROL”

STATEMENT_TYPE_SQLPLUS = 'SQLPLUS'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “SQLPLUS”

STATEMENT_TYPE_SYSTEM_CONTROL = 'SYSTEM_CONTROL'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “SYSTEM_CONTROL”

STATEMENT_TYPE_TRANSACTION_CONTROL = 'TRANSACTION_CONTROL'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript. This constant has a value of “TRANSACTION_CONTROL”

__init__(**kwargs)¶

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

Parameters:

statement_id (int) – The value to assign to the statement_id property of this ExecuteSqlResponseItemScript.
statement_type (str) – The value to assign to the statement_type property of this ExecuteSqlResponseItemScript. Allowed values for this property are: “QUERY”, “DML”, “DDL”, “PLSQL”, “SQLPLUS”, “IGNORE”, “TRANSACTION_CONTROL”, “SESSION_CONTROL”, “SYSTEM_CONTROL”, “JDBC”, “OTHER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
statement_pos (oci.database_tools_runtime.models.ExecuteSqlResponseItemStatementPos) – The value to assign to the statement_pos property of this ExecuteSqlResponseItemScript.
statement_text (str) – The value to assign to the statement_text property of this ExecuteSqlResponseItemScript.
error (oci.database_tools_runtime.models.ExecuteSqlResponseItemError) – The value to assign to the error property of this ExecuteSqlResponseItemScript.
dbms_output (str) – The value to assign to the dbms_output property of this ExecuteSqlResponseItemScript.
properties (oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties) – The value to assign to the properties property of this ExecuteSqlResponseItemScript.
responses (list[str]) – The value to assign to the responses property of this ExecuteSqlResponseItemScript.
results (list[int]) – The value to assign to the results property of this ExecuteSqlResponseItemScript.
result_set_object (oci.database_tools_runtime.models.ExecuteSqlOutputDispositionDetails) – The value to assign to the result_set_object property of this ExecuteSqlResponseItemScript.
result_set (oci.database_tools_runtime.models.ExecuteSqlResponseItemResultSet) – The value to assign to the result_set property of this ExecuteSqlResponseItemScript.
binds (list[oci.database_tools_runtime.models.ExecuteSqlBind]) – The value to assign to the binds property of this ExecuteSqlResponseItemScript.

binds¶

Gets the binds of this ExecuteSqlResponseItemScript. Array of objects specifying the bind information.

Returns:	The binds of this ExecuteSqlResponseItemScript.
Return type:	list[oci.database_tools_runtime.models.ExecuteSqlBind]

dbms_output¶

Gets the dbms_output of this ExecuteSqlResponseItemScript. Output from DBMS_OUTPUT package. Server output must be enabled (e.g., SET SERVEROUTPUT ON).

Returns:	The dbms_output of this ExecuteSqlResponseItemScript.
Return type:	str

error¶

Gets the error of this ExecuteSqlResponseItemScript.

Returns:	The error of this ExecuteSqlResponseItemScript.
Return type:	oci.database_tools_runtime.models.ExecuteSqlResponseItemError

properties¶

Gets the properties of this ExecuteSqlResponseItemScript.

Returns:	The properties of this ExecuteSqlResponseItemScript.
Return type:	oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties

responses¶

Gets the responses of this ExecuteSqlResponseItemScript. Responses generated when executing the statements.

Returns:	The responses of this ExecuteSqlResponseItemScript.
Return type:	list[str]

result_set¶

Gets the result_set of this ExecuteSqlResponseItemScript.

Returns:	The result_set of this ExecuteSqlResponseItemScript.
Return type:	oci.database_tools_runtime.models.ExecuteSqlResponseItemResultSet

result_set_object¶

Gets the result_set_object of this ExecuteSqlResponseItemScript.

Returns:	The result_set_object of this ExecuteSqlResponseItemScript.
Return type:	oci.database_tools_runtime.models.ExecuteSqlOutputDispositionDetails

results¶

Gets the results of this ExecuteSqlResponseItemScript. Results generated when executing the statements.

Returns:	The results of this ExecuteSqlResponseItemScript.
Return type:	list[int]

statement_id¶

Gets the statement_id of this ExecuteSqlResponseItemScript. The sequence number of the statement. Sequence number of the first statement is 1.

Returns:	The statement_id of this ExecuteSqlResponseItemScript.
Return type:	int

statement_pos¶

Gets the statement_pos of this ExecuteSqlResponseItemScript.

Returns:	The statement_pos of this ExecuteSqlResponseItemScript.
Return type:	oci.database_tools_runtime.models.ExecuteSqlResponseItemStatementPos

statement_text¶

Gets the statement_text of this ExecuteSqlResponseItemScript. Text of statements executed.

Returns:	The statement_text of this ExecuteSqlResponseItemScript.
Return type:	str

statement_type¶

Gets the statement_type of this ExecuteSqlResponseItemScript. The Statement type.

Allowed values for this property are: “QUERY”, “DML”, “DDL”, “PLSQL”, “SQLPLUS”, “IGNORE”, “TRANSACTION_CONTROL”, “SESSION_CONTROL”, “SYSTEM_CONTROL”, “JDBC”, “OTHER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The statement_type of this ExecuteSqlResponseItemScript.
Return type:	str