7.23. ODPI-C Structure dpiStmtInfo

This structure is used for passing information about a statement from ODPI-C. It is used by the function dpiStmt_getInfo().

int dpiStmtInfo.isQuery

Specifies if the statement refers to a query (1) or not (0).

int dpiStmtInfo.isPLSQL

Specifies if the statement refers to a PL/SQL block (1) or not (0).

int dpiStmtInfo.isDDL

Specifies if the statement refers to DDL (data definition language) such as creating a table (1) or not (0).

int dpiStmtInfo.isDML

Specifies if the statement refers to DML (data manipulation language) such as inserting, updating and deleting (1) or not (0).

dpiStatementType dpiStmtInfo.statementType

Specifies the type of statement that has been prepared. The members dpiStmtInfo.isQuery, dpiStmtInfo.isPLSQL, dpiStmtInfo.isDDL and dpiStmtInfo.isDML are all categorizations of this value. It will be one of the values from the enumeration dpiStatementType.

int dpiStmtInfo.isReturning

Specifies if the statement has a returning clause in it (1) or not (0).