ExecuteSqlResponseItemBatch¶

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

Bases: object

A statement execution response for batched type requests.

Attributes

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

Methods

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

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

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

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

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

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

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

STATEMENT_TYPE_QUERY = 'QUERY'¶: A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch. 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 ExecuteSqlResponseItemBatch. 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 ExecuteSqlResponseItemBatch. 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 ExecuteSqlResponseItemBatch. 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 ExecuteSqlResponseItemBatch. This constant has a value of “TRANSACTION_CONTROL”

__init__(**kwargs)¶

Initializes a new ExecuteSqlResponseItemBatch 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 ExecuteSqlResponseItemBatch.
statement_type (str) – The value to assign to the statement_type property of this ExecuteSqlResponseItemBatch. 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 ExecuteSqlResponseItemBatch.
batch_statement_texts (list[str]) – The value to assign to the batch_statement_texts property of this ExecuteSqlResponseItemBatch.
error (oci.database_tools_runtime.models.ExecuteSqlResponseItemError) – The value to assign to the error property of this ExecuteSqlResponseItemBatch.
dbms_output (str) – The value to assign to the dbms_output property of this ExecuteSqlResponseItemBatch.
properties (oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties) – The value to assign to the properties property of this ExecuteSqlResponseItemBatch.
responses (list[str]) – The value to assign to the responses property of this ExecuteSqlResponseItemBatch.
results (list[int]) – The value to assign to the results property of this ExecuteSqlResponseItemBatch.

batch_statement_texts¶

Gets the batch_statement_texts of this ExecuteSqlResponseItemBatch. DML statements to execute in jdbc batch mode

Returns:	The batch_statement_texts of this ExecuteSqlResponseItemBatch.
Return type:	list[str]

dbms_output¶

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

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

error¶

Gets the error of this ExecuteSqlResponseItemBatch.

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

properties¶

Gets the properties of this ExecuteSqlResponseItemBatch.

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

responses¶

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

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

results¶

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

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

statement_id¶

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

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

statement_pos¶

Gets the statement_pos of this ExecuteSqlResponseItemBatch.

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

statement_type¶

Gets the statement_type of this ExecuteSqlResponseItemBatch. 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 ExecuteSqlResponseItemBatch.
Return type:	str