EXEC_SQL
built-in package Procedure/Exception/Function |
Description |
function that opens a connection and assigns it a connection handle |
|
function that returns a connection handle that uses the same database connection originally established by Oracle Reports |
|
function that returns a connection handle that uses the same database connection originally established |
|
function that creates a new cursor on a specified connection and returns a cursor handle |
|
procedure that parses a statement on a specified cursor |
|
procedure that obtains information about the columns in a result set of a parsed SQL statement |
|
procedure that binds a given value to a named variable in a SQL statement |
|
procedure that is used only with |
|
procedure that executes the SQL statement at a specified cursor |
|
function that calls |
|
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 |
procedure that returns the value of the cursor for a given position in a given cursor |
|
procedure that retrieves the output value of a named bind variable at a specified cursor |
|
fuction that returns |
|
procedure that closes a specified cursor and releases the memory allocated to it |
|
function that returns |
|
function that returns |
|
procedure that releases any resources used by the connection handle and invalidates it |
|
function that returns the byte offset in the SQL statement where an error occurred |
|
function that returns the cumulative number of rows fetched |
|
function that returns the last SQL function code, indicating the type of SQL statement |
|
function that returns the last Oracle error code raised on a connection |
|
function that returns the text message of the last error code raised on a connection |
About the EXEC_SQL
built-in package
EXEC_SQL
built-in package
examples
Changing the primary database connection
Copying data between two databases
EXEC_SQL
predefined exceptions
Retrieving result sets from queries or non-Oracle stored procedures
Copyright © 1984, 2005, Oracle. All rights reserved.