ExecuteSqlResponseItemScript¶
- class oci.database_tools_runtime.models.ExecuteSqlResponseItemScript(**kwargs)¶
Bases:
objectA statement execution response for script type requests.
Attributes:
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
A constant which can be used with the statement_type property of a ExecuteSqlResponseItemScript.
Gets the binds of this ExecuteSqlResponseItemScript.
Gets the dbms_output of this ExecuteSqlResponseItemScript.
Gets the error of this ExecuteSqlResponseItemScript.
Gets the properties of this ExecuteSqlResponseItemScript.
Gets the responses of this ExecuteSqlResponseItemScript.
Gets the result_set of this ExecuteSqlResponseItemScript.
Gets the result_set_object of this ExecuteSqlResponseItemScript.
Gets the results of this ExecuteSqlResponseItemScript.
Gets the statement_id of this ExecuteSqlResponseItemScript.
Gets the statement_pos of this ExecuteSqlResponseItemScript.
Gets the statement_text of this ExecuteSqlResponseItemScript.
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
- 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