Cursor variables pass query result sets - SQL Operations

Q.  You use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients.
- Published on 09 Jul 15

a. Yes
b. No

ANSWER: Yes
 
You use cursor variables to pass query result sets between PL/SQL stored subprograms and client programs because any client program or PL/SQL does not own a result set, a pointer is shared in the work area where the result set will be stored.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)