PL/SQL Packages DBMS_HS_PASSTHROUGH

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
:



 
Copyright © 1999-2024 SS64.com
Some rights reserved