ExecuteSqlResponseItemBatch¶
- class oci.database_tools_runtime.models.ExecuteSqlResponseItemBatch(**kwargs)¶
Bases:
objectA statement execution response for batched type requests.
Attributes:
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemBatch.
Gets the batch_statement_texts of this ExecuteSqlResponseItemBatch.
Gets the dbms_output of this ExecuteSqlResponseItemBatch.
Gets the error of this ExecuteSqlResponseItemBatch.
Gets the properties of this ExecuteSqlResponseItemBatch.
Gets the responses of this ExecuteSqlResponseItemBatch.
Gets the results of this ExecuteSqlResponseItemBatch.
Gets the statement_id of this ExecuteSqlResponseItemBatch.
Gets the statement_pos of this ExecuteSqlResponseItemBatch.
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.
- property 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]
- property 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
- property error¶
Gets the error of this ExecuteSqlResponseItemBatch.
- Returns
The error of this ExecuteSqlResponseItemBatch.
- Return type
oci.database_tools_runtime.models.ExecuteSqlResponseItemError
- property properties¶
Gets the properties of this ExecuteSqlResponseItemBatch.
- Returns
The properties of this ExecuteSqlResponseItemBatch.
- Return type
oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties
- property responses¶
Gets the responses of this ExecuteSqlResponseItemBatch. Responses generated when executing the statements.
- Returns
The responses of this ExecuteSqlResponseItemBatch.
- Return type
list[str]
- property results¶
Gets the results of this ExecuteSqlResponseItemBatch. Results generated when executing the statements.
- Returns
The results of this ExecuteSqlResponseItemBatch.
- Return type
list[int]
- property 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
- property statement_pos¶
Gets the statement_pos of this ExecuteSqlResponseItemBatch.
- Returns
The statement_pos of this ExecuteSqlResponseItemBatch.
- Return type
oci.database_tools_runtime.models.ExecuteSqlResponseItemStatementPos
- property 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