DBMS_SQL

The DBMS_SQL package provides an interface for using dynamic SQL to accomplish any of the following:

Execute data manipulation language (DML) and data definition language (DDL) statements.
Execute PL/SQL anonymous blocks.
Call PL/SQL stored procedures and functions.

This package does not support pre-defined data types and overloads with data types that are not supported in TimesTen, such as UROWID, time zone features, ADT, database-level collections, and edition overloads. For more information on the supported data types in TimesTen PL/SQL, see Understanding the Data Type Environments.

Table 7-6 describes the DBMS_SQL subprograms.

Table 7-6 DBMS_SQL Subprograms

Subprogram	Description
`BIND_ARRAY` procedure	Binds a given value to a given collection.
`BIND_VARIABLE` procedure	Binds a given value to a given variable.
`CLOSE_CURSOR` procedure	Closes a given cursor and frees memory.
`COLUMN_VALUE` procedure	Returns the value of the cursor element for a given position in a cursor.
`COLUMN_VALUE_LONG` procedure	Returns a selected part of a `LONG` column that has been defined using `DEFINE_COLUMN_LONG`. Important: Because TimesTen does not support the `LONG` data type, attempting to use this procedure in TimesTen results in an `ORA-01018` error at runtime.
`DEFINE_ARRAY` procedure	Defines a collection to be selected from the given cursor. Use with `SELECT` statements.
`DEFINE_COLUMN` procedure	Defines a column to be selected from the given cursor. Use with `SELECT` statements.
`DEFINE_COLUMN_LONG` procedure	Defines a `LONG` column to be selected from the given cursor. Use with `SELECT` statements. Important: Because TimesTen does not support the `LONG` data type, attempting to use the `COLUMN_VALUE_LONG` procedure in TimesTen results in an `ORA-01018` error at runtime. `DEFINE_COLUMN_LONG` would be used with `COLUMN_VALUE_LONG`.
`DESCRIBE_COLUMNS` procedure	Describes the columns for a cursor opened and parsed through the `DBMS_SQL` package.
`DESCRIBE_COLUMNS2` procedure	Describes the specified column. Use as an alternative to `DESCRIBE_COLUMNS` procedure.
`DESCRIBE_COLUMNS3` procedure	Describes the specified column. Use as an alternative to `DESCRIBE_COLUMNS` procedure.
`EXECUTE` function	Executes a given cursor.
`EXECUTE_AND_FETCH` function	Executes a given cursor and fetches rows.
`FETCH_ROWS` function	Fetches a row from a given cursor.
`IS_OPEN` function	Returns `TRUE` if a given cursor is open.
`LAST_ERROR_POSITION` function	Returns the byte offset in the SQL statement text where the error occurred.
`LAST_ROW_COUNT` function	Returns a cumulative count of the number of rows fetched.
`LAST_ROW_ID` function	Returns `NULL`. TimesTen does not support `ROWID` of the last row operated on by a DML statement.
`LAST_SQL_FUNCTION_CODE` function	Returns the SQL function code for the statement.
`OPEN_CURSOR` function	Returns the cursor ID number of a new cursor.
`PARSE` procedures	Parses a given statement.
`TO_CURSOR_NUMBER` function	Takes an opened (by `OPEN`) strongly or weakly typed REF CURSOR and transforms it into a `DBMS_SQL` cursor number.
`TO_REFCURSOR` function	Takes an opened, parsed, and executed cursor (by `OPEN`, `PARSE`, and `EXECUTE`) and transforms or migrates it into a PL/SQL manageable REF CURSOR (a weakly typed cursor) that can be consumed by PL/SQL native dynamic SQL and switched to use native dynamic SQL.
`VARIABLE_VALUE` procedures	Returns value of a named variable for a given cursor.