A script-enabled browser is required for this page to function properly.

EXEC_SQL built-in package

Procedure/Exception/Function

Description

EXEC_SQL.OPEN_CONNECTION

function that opens a connection and assigns it a connection handle

EXEC_SQL.CURR_CONNECTION

function that returns a connection handle that uses the same database connection originally established by Oracle Reports

EXEC_SQL.DEFAULT_CONNECTION

function that returns a connection handle that uses the same database connection originally established

EXEC_SQL.OPEN_CURSOR

function that creates a new cursor on a specified connection and returns a cursor handle

EXEC_SQL.PARSE

procedure that parses a statement on a specified cursor

EXEC_SQL.DESCRIBE_COLUMN

procedure that obtains information about the columns in a result set of a parsed SQL statement

EXEC_SQL.BIND_VARIABLE

procedure that binds a given value to a named variable in a SQL statement

EXEC_SQL.DEFINE_COLUMN

procedure that is used only with SELECT statements or calls to non-Oracle stored procedures that return a result set

EXEC_SQL.EXECUTE

procedure that executes the SQL statement at a specified cursor

EXEC_SQL.EXECUTE_AND_FETCH

function that calls EXEC_SQL.EXECUTE and then EXEC_SQL.FETCH_ROWS, and executes a SQL statement at a specified cursor and retrieves the first row that satisfies the query

EXEC_SQL.FETCH_ROWS

function that retrieves a row that satisfies the query at a specified cursor

EXEC_SQL.MORE_RESULT_SETS function that applies to non-Oracle connections only, and determines if there is another result set to retrieve for a specified cursor

EXEC_SQL.COLUMN_VALUE

procedure that returns the value of the cursor for a given position in a given cursor

EXEC_SQL.VARIABLE_VALUE

procedure that retrieves the output value of a named bind variable at a specified cursor

EXEC_SQL.IS_OPEN

fuction that returns TRUE if a specified cursor is currently open on a specified connection

EXEC_SQL.CLOSE_CURSOR

procedure that closes a specified cursor and releases the memory allocated to it

EXEC_SQL.IS_CONNECTED

function that returns TRUE if a specified connection handle is currently connected to a data source

EXEC_SQL.IS_OCA_CONNECTION

function that returns TRUE if a specified connection handle is for an OCA connection

EXEC_SQL.CLOSE_CONNECTION

procedure that releases any resources used by the connection handle and invalidates it

EXEC_SQL.LAST_ERROR_POSITION

function that returns the byte offset in the SQL statement where an error occurred

EXEC_SQL.LAST_ROW_COUNT

function that returns the cumulative number of rows fetched

EXEC_SQL.LAST_SQL_FUNCTION_CODE

function that returns the last SQL function code, indicating the type of SQL statement

EXEC_SQL.LAST_ERROR_CODE

function that returns the last Oracle error code raised on a connection

EXEC_SQL.LAST_ERROR_MESG

function that returns the text message of the last error code raised on a connection

See also

About the EXEC_SQL built-in package

EXEC_SQL built-in package examples

Changing the primary database connection

Connection and cursor handles

Copying data between two databases

EXEC_SQL predefined exceptions

Retrieving result sets from queries or non-Oracle stored procedures

About built-in packages