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: