Re: returning custom selections in pl/sql

Return a single row or a collection of rows?

If a singel row just:

SELECT field1, field2, field3
INTO var1, var2, var3
FROM mytable;

Then make var1, var2, and var3 out parameters in your procedure.

If a collection of rows use a ref cursor.

Daniel Morgan

humble_one wrote:

> hi,
> it would be great if some one could tell me how to do the following
> efficiently using a function / procedure in pl/sql
>
> i have 2 tables A and B, and i wish to select and return fields a.1,
> b.1, b.2, b.3, b.4 given b.4.
>
> TIA,
> K
Received on Wed Mar 20 2002 - 14:00:00 CST