Send a statement directly to a non-Oracle system without being interpreted by the Oracle server
Subprocedures:
BIND_VARIABLE Bind an IN variable positionally with a PL/SQL program variable.
BIND_VARIABLE_RAW Bind IN variables of type RAW.
BIND_OUT_VARIABLE Bind an OUT variable with a PL/SQL program variable.
BIND_OUT_VARIABLE_RAW Bind an OUT variable of datatype RAW with a PL/SQL program variable.
BIND_INOUT_VARIABLE Bind IN OUT bind variables.
BIND_INOUT_VARIABLE_RAW Bind IN OUT bind variables of datatype RAW.
CLOSE_CURSOR Close a cursor and release associated memory after the
SQL statement has been run at the non-Oracle system.
EXECUTE_IMMEDIATE Run a (non-SELECT) SQL statement immediately, without bind variables.
EXECUTE_NON_QUERY Function Runs a (non-SELECT) SQL statement.
FETCH_ROW Function Fetches rows from a query.
GET_VALUE Retrieves column value from SELECT statement, or retrieve
OUT bind parameters.
GET_VALUE_RAW Similar to GET_VALUE, but for datatype RAW.
OPEN_CURSOR Function Open a cursor for running a passthrough SQL statement at
the non-Oracle system.
PARSE Parses SQL statement at non-Oracle system.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:
Related Packages: