Execute Passthrough SQL Statements

The following table shows the functions and procedures provided by the DBMS_HS_PASSTHROUGH package that enable you to execute passthrough SQL statements.

Procedure/Function	Description
`OPEN_CURSOR`	Opens a cursor.
`CLOSE_CURSOR`	Closes a cursor.
`PARSE`	Parses the statement.
`BIND_VARIABLE`	Binds `IN` variables.
`BIND_OUT_VARIABLE`	Binds `OUT` variables.
`BIND_INOUT_VARIABLE`	Binds `IN OUT` variables.
`EXECUTE_NON_QUERY`	Executes a nonquery statement.
`EXECUTE_IMMEDIATE`	Executes a nonquery statement without bind variables.
`FETCH_ROW`	Fetches rows from query.
`GET_VALUE`	Retrieves column value from `SELECT` statement or retrieves `OUT` bind parameters.