Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SQL , 2 of 20
This procedure opens a new cursor. When you no longer need this cursor, you must close it explicitly by calling CLOSE_CURSOR
.
You can use cursors to run the same SQL statement repeatedly or to run a new SQL statement. When a cursor is reused, the contents of the corresponding cursor data area are reset when the new SQL statement is parsed. It is never necessary to close and reopen a cursor before reusing it.
DBMS_SQL.OPEN_CURSOR RETURN INTEGER;
pragma restrict_references(open_cursor,RNDS,WNDS);
This function returns the cursor ID number of the new cursor.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|