Oracle Heterogeneous Services Release 8.1.7 Part Number A88714-01 |
|
The package DBMS_HS_PASSTHROUGH contains the procedures and functions for pass-through SQL of Heterogeneous Services.
This appendix contains these topics:
See Also:
Chapter 4, "Developing Applications with Heterogeneous Services" for more information about this package. |
This procedure binds an IN variable positionally with a PL/SQL program variable. Syntax.
DBMS_HS_PASSTHROUGH.BIND_VARIABLE ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN dty [,name IN VARCHAR2]);
Where dty is one of
Purity levels defined: WNDS, RNDS
This procedure binds IN variables of type RAW.
DBMS_HS_PASSTHROUGH.BIND_VARIABLE_RAW ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN RAW [,name IN VARCHAR2]);
Purity level defined: WNDS, RNDS
This procedure binds an OUT variable with a PL/SQL program variable.
See Also:
See Chapter 4, "Developing Applications with Heterogeneous Services" for more information about binding OUT parameters. |
DBMS_HS_PASSTHROUGH.BIND_OUT_VARIABLE ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val OUT dty, [,name IN VARCHAR2]);
Where dty is one of
Purity level defined: WNDS, RNDS
This procedure binds an OUT variable of datatype RAW with a PL/SQL program variable.
See Also:
Chapter 4, "Developing Applications with Heterogeneous Services" for more information on binding OUT parameters. |
DBMS_HS_PASSTHROUGH.BIND_OUT_VARIABLE ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val OUT RAW, [,name IN VARCHAR2]);
Pragmas defined: WNDS, RNDS
This procedure binds IN OUT bind variables.
See Also:
Chapter 4, "Developing Applications with Heterogeneous Services" for more information on binding IN OUT parameters. |
DBMS_HS_PASSTHROUGH.BIND_INOUT_VARIABLE ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN OUT dty, [,name IN VARCHAR2]);
Where dty is one of
For binding IN OUT variables of datatype RAW, see BIND_INOUT_VARIABLE_RAW.
Purity level defined: WNDS, RNDS
This procedure binds IN OUT bind variables of datatype RAW.
See Also :
Chapter 4, "Developing Applications with Heterogeneous Services" for more information on binding IN OUT parameters. |
DBMS_HS_PASSTHROUGH.BIND_INOUT_VARIABLE ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val IN OUT RAW, [,name IN VARCHAR2]);
Pragmas defined: WNDS, RNDS
This function closes the cursor and releases associated memory after the SQL statement has been executed at the non-Oracle system. If the cursor was not open, the operation is a no operation.
DBMS_HS_PASSTHROUGH.CLOSE_CURSOR ( c IN BINARY_INTEGER NOT NULL);
Parameter | Description |
---|---|
c |
Cursor to be released. |
Exception | Description |
---|---|
ORA-28555 |
A NULL value was passed for a NOT NULL parameter. |
Purity level defined: WNDS, RNDS
This function executes a SQL statement immediately. Any valid SQL command except SELECT can be executed immediately, but the statement must not contain any bind variables. The statement is passed in as a VARCHAR2 in the argument. Internally, the SQL statement is executed using the PASSTHROUGH SQL protocol sequence of OPEN_CURSOR, PARSE, EXECUTE_NON_QUERY, CLOSE_CURSOR.
EXECUTE_IMMEDIATE ( s IN VARCHAR2 NOT NULL ) RETURN BINARY_INTEGER;
Parameter | Description |
---|---|
s |
VARCHAR2 variable with the statement to be executed immediately. |
The number of rows affected by the execution of the SQL statement.
Exception | Description |
---|---|
ORA-28544 |
Max open cursors. |
ORA-28551 |
SQL statement is invalid. |
ORA-28555 |
A NULL value was passed for a NOT NULL parameter. |
Purity level defined: NONE
This function executes any SQL statement other than a SELECT statement. A cursor has to be open and the SQL statement has to be parsed before the SQL statement can be executed.
DBMS_HS_PASSTHROUGH.EXECUTE_NON_QUERY ( c IN BINARY_INTEGER NOT NULL) RETURN BINARY_INTEGER;
Parameter | Description |
---|---|
c |
Cursor associated with the pass-through SQL statement. Cursor must be opened and parsed, using the routines OPEN_CURSOR and PARSE respectively. |
The number of rows affected by the SQL statement in the non-Oracle system.
Purity level defined: NONE
This function fetches rows from a result set. The result set is defined with a SQL SELECT statement.
Before the rows can be fetched, a cursor has to be opened, and the SQL statement has to be parsed. When there are no more rows to be fetched, the function returns 0. After a 0 return, the NO_DATA_FOUND exception occurs when:
DBMS_HS_PASSTHROUGH.FETCH_ROW ( c IN BINARY_INTEGER NOT NULL [,first IN BOOLEAN]) RETURN BINARY_INTEGER;
The returns the number of rows fetched. The function will return 0 if the last row was already fetched.
Purity level defined: WNDS
This procedure has two purposes:
DBMS_HS_PASSTHROUGH.GET_VALUE ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val OUT dty);
Where dty is one of
For retrieving values of datatype RAW, see GET_VALUE_RAW.
Purity level defined: WNDS
This procedure, which operates on RAW datatypes, has two purposes:
DBMS_HS_PASSTHROUGH.GET_VALUE_RAW ( c IN BINARY_INTEGER NOT NULL, pos IN BINARY_INTEGER NOT NULL, val OUT RAW);
Purity level defined: WNDS
This function opens a cursor for executing a pass-through SQL statement at the non-Oracle system. This function must be called for any type of SQL statement The function returns a cursor, which must be used in subsequent calls. This call allocates memory. To deallocate the associated memory, you call the procedure DBMS_HS_PASSTHROUGH.CLOSE_CURSOR.
DBMS_HS_PASSTHROUGH.OPEN_CURSOR () RETURN BINARY_INTEGER;
The cursor to be used on subsequent procedure and function calls.
Exception | Description |
---|---|
ORA-28554 |
Maximum number of open cursor has been exceeded. Increase Heterogeneous Services' OPEN_CURSORS initialization parameter. |
Purity level defined: WNDS, RNDS
This procedure parses SQL statement at non-Oracle system.
DBMS_HS_PASSTHROUGH.GET_VALUE_RAW ( c IN BINARY_INTEGER NOT NULL, stmt IN VARCHAR2 NOT NULL);
Parameter | Description |
---|---|
c |
Cursor associated with the pass-through SQL statement. Cursor must be opened using function OPEN_CURSOR. |
stmt |
Statement to be parsed. |
Exception | Description |
---|---|
ORA-28550 |
The cursor passed is invalid. |
ORA-28551 |
SQL statement is illegal. |
ORA-28555 |
A NULL value was passed for a NOT NULL parameter. |
Purity level defined: WNDS, RNDS
|
Copyright © 1996-2001 Oracle Corporation. All Rights Reserved. |
|