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.

property 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]

property 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

property error

Gets the error of this ExecuteSqlResponseItemScript.

Returns

The error of this ExecuteSqlResponseItemScript.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemError

property properties

Gets the properties of this ExecuteSqlResponseItemScript.

Returns

The properties of this ExecuteSqlResponseItemScript.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemProperties

property responses

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

Returns

The responses of this ExecuteSqlResponseItemScript.

Return type

list[str]

property result_set

Gets the result_set of this ExecuteSqlResponseItemScript.

Returns

The result_set of this ExecuteSqlResponseItemScript.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemResultSet

property 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

property results

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

Returns

The results of this ExecuteSqlResponseItemScript.

Return type

list[int]

property 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

property statement_pos

Gets the statement_pos of this ExecuteSqlResponseItemScript.

Returns

The statement_pos of this ExecuteSqlResponseItemScript.

Return type

oci.database_tools_runtime.models.ExecuteSqlResponseItemStatementPos

property statement_text

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

Returns

The statement_text of this ExecuteSqlResponseItemScript.

Return type

str

property 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