Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_HS_PASSTHROUGH, 9 of 15
This function runs a SQL statement immediately. Any valid SQL command except SELECT
can be run immediately. The statement must not contain any bind variables. The statement is passed in as a VARCHAR2
in the argument. Internally the SQL statement is run using the PASSTHROUGH
SQL protocol sequence of OPEN_CURSOR
, PARSE
, EXECUTE_NON_QUERY
, CLOSE_CURSOR
.
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE ( S IN VARCHAR2 NOT NULL) RETURN BINARY_INTEGER;
Parameter | Description |
---|---|
s |
|
The number of rows affected by the execution of the SQL statement.
Exception | Description |
---|---|
ORA-28551 |
SQL statement is invalid. |
ORA-28544 |
Max open cursors. |
ORA-28555 |
A |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|