Oracle in a Nutshell

Calls

PROCEDURE DBMS_HS_PASSTHROUGH.BIND_VARIABLE (c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN {DATE | NUMBER | VARCHAR2}, name IN VARCHAR2);

Binds val to cursor c in postion pos on remote system.

PROCEDURE DBMS_HS_PASSTHROUGH.BIND_VARIABLE_RAW (c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN RAW, name IN VARCHAR2);

Binds raw val to cursor c in postion pos on remote system.

PROCEDURE DBMS_HS_PASSTHROUGH.BIND_OUT_VARIABLE (c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val OUT {DATE | NUMBER | VARCHAR2}, name IN VARCHAR2);

Binds OUT val to cursor c in postion pos in a PL/SQL program variable.

PROCEDURE DBMS_HS_PASSTHROUGH.BIND_OUT_VARIABLE_RAW (c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val OUT RAW, name IN VARCHAR2);

Binds OUT RAW val to cursor c in postion pos in a PL/SQL program variable.

PROCEDURE DBMS_HS_PASSTHROUGH.BIND_INOUT_VARIABLE (c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN OUT {DATE | NUMBER | VARCHAR2}, name IN VARCHAR2);

Binds IN OUT val to cursor c in postion pos in a PL/SQL program variable.

PROCEDURE DBMS_HS_PASSTHROUGH.BIND_INOUT_VARIABLE_RAW (c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN OUT RAW, name IN VARCHAR2);

Binds IN OUT RAW val to cursor c in postion pos in a PL/SQL program variable.

PROCEDURE DBMS_HS_PASSTHROUGH.CLOSE_CURSOR (c IN BINARY_INTEGER NOT NULL);

Closes cursor c and releases memory after statement run on a non-Oracle ...