Re: Query in a Stored Procedure

In article <f4juotg39qhsd5107f50krnj55pfli9hr0_at_4ax.com>, John says...
>
>On Thu, 30 Aug 2001 15:35:13 +0100, "Niall Litchfield"
><n-litchfield_at_audit-commission.gov.uk> wrote:
>>As a side note It would perhaps be nice if the Oracle documentation could
>>refer to resultsets as well as ref cursors, if only to cut down on the
>>amount of hassle different terminology causes.
>
>Perhaps someday it will... perhaps tomorrow. :-) (Is it really
>"resultset" all as one word?)
>
>John
>--
>Got an Oracle database question?
>Try the search engine for the database docs at:
>http://tahiti.oracle.com/

It already does (yesterday). Actually -- use your link in your signature and plug in "result set"

It is "result set" and we do call them that (i got bored counting the occurrences of result set in the plsql guide but here are two examples in conjunction with cursor variables)

Cursor Variables

Like a cursor, a cursor variable points to the current row in the result set of a multi-row query. But, unlike a cursor, a cursor variable can be opened for any type-compatible query. It is not tied to a specific query. Cursor variables are true PL/SQL variables, to which you can assign new values and which you can pass to subprograms stored in an Oracle database. This gives you more flexibility and a convenient way to centralize data retrieval.

....
Why Use Cursor Variables?

Mainly, you use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients. Neither PL/SQL nor any of its clients owns a result set; they simply share a pointer to the query work area in which the result set is stored. For example, an OCI client, Oracle Forms application, and Oracle server can all refer to the same work area.

In fact, if you goto the index -- "result set" is in there as well.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp