17
DBMS_HS_PASSTHROUGH

The pass-through SQL feature allows an application developer to send a statement directly to a non-Oracle system without being interpreted by the Oracle server. This can be useful if the non-Oracle system allows for operations in statements for which there is no equivalent in Oracle.

You can run these statements directly at the non-Oracle system using the PL/SQL package DBMS_HS_PASSTHROUGH. Any statement executed with this package is run in the same transaction as regular "transparent" SQL statements.

See Also: For detailed information on Heterogeneous Services and on binding variables, see Oracle9i Distributed Database Systems.

This chapter discusses the following topics:

• Security

• Summary of DBMS_HS_PASSTHROUGH Subprograms

Security

The DBMS_HS_PASSTHROUGH package conceptually resides at the non-Oracle system. Procedures and functions in the package must be called by using the appropriate database link to the non-Oracle system.

Summary of DBMS_HS_PASSTHROUGH Subprograms

Table 17-1 DBMS_HS_PASSTHROUGH Package Subprograms  

Subprogram	Description
"BIND_VARIABLE Procedure"	Binds an IN variable positionally with a PL/SQL program variable.
"BIND_VARIABLE_RAW Procedure"	Binds IN variables of type RAW.
"BIND_OUT_VARIABLE Procedure"	Binds an OUT variable with a PL/SQL program variable.
"BIND_OUT_VARIABLE_RAW Procedure"	Binds an OUT variable of datatype RAW with a PL/SQL program variable.
"BIND_INOUT_VARIABLE Procedure"	Binds IN OUT bind variables.
"BIND_INOUT_VARIABLE_RAW Procedure"	Binds IN OUT bind variables of datatype RAW.
"CLOSE_CURSOR Procedure"	Closes the cursor and releases associated memory after the SQL statement has been run at the non-Oracle system.
"EXECUTE_IMMEDIATE Procedure"	Runs 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 Procedure"	Retrieves column value from SELECT statement, or retrieves OUT bind parameters.
"GET_VALUE_RAW Procedure"	Similar to GET_VALUE, but for datatype RAW.
"OPEN_CURSOR Function"	Opens a cursor for running a passthrough SQL statement at the non-Oracle system.
"PARSE Procedure"	Parses SQL statement at non-Oracle system.