ExecuteSqlResponseItemStandard

class oci.database_tools_runtime.models.ExecuteSqlResponseItemStandard(**kwargs)

Bases: object

A statement execution response for Standard type requests.

Attributes:

STATEMENT_TYPE_DDL

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_DML

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_IGNORE

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_JDBC

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_OTHER

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_PLSQL

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_QUERY

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_SESSION_CONTROL

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_SQLPLUS

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_SYSTEM_CONTROL

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

STATEMENT_TYPE_TRANSACTION_CONTROL

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard.

binds

Gets the binds of this ExecuteSqlResponseItemStandard.

dbms_output

Gets the dbms_output of this ExecuteSqlResponseItemStandard.

error

Gets the error of this ExecuteSqlResponseItemStandard.

properties

Gets the properties of this ExecuteSqlResponseItemStandard.

responses

Gets the responses of this ExecuteSqlResponseItemStandard.

result_set

Gets the result_set of this ExecuteSqlResponseItemStandard.

result_set_object

Gets the result_set_object of this ExecuteSqlResponseItemStandard.

results

Gets the results of this ExecuteSqlResponseItemStandard.

statement_id

Gets the statement_id of this ExecuteSqlResponseItemStandard.

statement_pos

Gets the statement_pos of this ExecuteSqlResponseItemStandard.

statement_text

Gets the statement_text of this ExecuteSqlResponseItemStandard.

statement_type

Gets the statement_type of this ExecuteSqlResponseItemStandard.

Methods:

__init__(**kwargs)

Initializes a new ExecuteSqlResponseItemStandard object with values from keyword arguments.

STATEMENT_TYPE_DDL = 'DDL'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. This constant has a value of “DDL”

STATEMENT_TYPE_DML = 'DML'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. This constant has a value of “DML”

STATEMENT_TYPE_IGNORE = 'IGNORE'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. This constant has a value of “IGNORE”

STATEMENT_TYPE_JDBC = 'JDBC'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. This constant has a value of “JDBC”

STATEMENT_TYPE_OTHER = 'OTHER'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. This constant has a value of “OTHER”

STATEMENT_TYPE_PLSQL = 'PLSQL'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. This constant has a value of “PLSQL”

STATEMENT_TYPE_QUERY = 'QUERY'

A constant which can be used with the statement_type property of a ExecuteSqlResponseItemStandard. 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 ExecuteSqlResponseItemStandard. 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 ExecuteSqlResponseItemStandard. 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 ExecuteSqlResponseItemStandard. 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 ExecuteSqlResponseItemStandard. This constant has a value of “TRANSACTION_CONTROL”

__init__(**kwargs)

Initializes a new ExecuteSqlResponseItemStandard 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 ExecuteSqlResponseItemStandard.

  • statement_type (str) – The value to assign to the statement_type property of this ExecuteSqlResponseItemStandard. 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 ExecuteSqlResponseItemStandard.

  • statement_text (str) – The value to assign to the statement_text property of this ExecuteSqlResponseItemStandard.

  • error (oci.database_tools_runtime.models.ExecuteSqlResponseItemError) – The value to assign to the error property of this ExecuteSqlResponseItemStandard.

  • dbms_output (str) – The value to assign to the dbms_output property of this ExecuteSqlResponseItemStandard.

  • properties (oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties) – The value to assign to the properties property of this ExecuteSqlResponseItemStandard.

  • responses (list[str]) – The value to assign to the responses property of this ExecuteSqlResponseItemStandard.

  • results (list[int]) – The value to assign to the results property of this ExecuteSqlResponseItemStandard.

  • result_set_object (oci.database_tools_runtime.models.ExecuteSqlOutputDispositionDetails) – The value to assign to the result_set_object property of this ExecuteSqlResponseItemStandard.

  • result_set (oci.database_tools_runtime.models.ExecuteSqlResponseItemResultSet) – The value to assign to the result_set property of this ExecuteSqlResponseItemStandard.

  • binds (list[oci.database_tools_runtime.models.ExecuteSqlBind]) – The value to assign to the binds property of this ExecuteSqlResponseItemStandard.

property binds

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

Returns

The binds of this ExecuteSqlResponseItemStandard.

Return type

list[oci.database_tools_runtime.models.ExecuteSqlBind]

property dbms_output

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

Returns

The dbms_output of this ExecuteSqlResponseItemStandard.

Return type

str

property error

Gets the error of this ExecuteSqlResponseItemStandard.

Returns

The error of this ExecuteSqlResponseItemStandard.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemError

property properties

Gets the properties of this ExecuteSqlResponseItemStandard.

Returns

The properties of this ExecuteSqlResponseItemStandard.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties

property responses

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

Returns

The responses of this ExecuteSqlResponseItemStandard.

Return type

list[str]

property result_set

Gets the result_set of this ExecuteSqlResponseItemStandard.

Returns

The result_set of this ExecuteSqlResponseItemStandard.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemResultSet

property result_set_object

Gets the result_set_object of this ExecuteSqlResponseItemStandard.

Returns

The result_set_object of this ExecuteSqlResponseItemStandard.

Return type

oci.database_tools_runtime.models.ExecuteSqlOutputDispositionDetails

property results

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

Returns

The results of this ExecuteSqlResponseItemStandard.

Return type

list[int]

property statement_id

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

Returns

The statement_id of this ExecuteSqlResponseItemStandard.

Return type

int

property statement_pos

Gets the statement_pos of this ExecuteSqlResponseItemStandard.

Returns

The statement_pos of this ExecuteSqlResponseItemStandard.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemStatementPos

property statement_text

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

Returns

The statement_text of this ExecuteSqlResponseItemStandard.

Return type

str

property statement_type

Gets the statement_type of this ExecuteSqlResponseItemStandard. 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 ExecuteSqlResponseItemStandard.

Return type

str