Re: Closing PL/SQL cursor

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 27 Sep 1999 19:21:54 GMT
Message-ID: <19990927152154.09489.00000828@ngol06.aol.com>

In article <37EF3358.C8EA937C_at_theleme.com>, Yann Chevriaux <chevriaux_at_theleme.com> writes:

>SQL_TEXT
>-----------------------------------------------------------
> 7 SCOTT
>select sid, user_name, sql_text from v$open_cursor
>
> 7 SCOTT
>SELECT DUMMY FROM DUAL
The above entries are implicit cursors....

Implicit Cursors
Oracle implicitly opens a cursor to process each SQL statement not associated with an explicitly declared cursor. PL/SQL lets you refer to the most recent implicit cursor as the SQL cursor.

Paul in VT Received on Mon Sep 27 1999 - 14:21:54 CDT