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.

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