Re: Oracle 9i PL/SQL Collection Question

Aaron Rouse wrote:

> I am extremely new to PL/SQL so would not be surprised if maybe I am
> tackling this in the wrong manner, also hope this is the right place
> to ask on this. I have a function that I am building and part of the
> function has a cursor that returns three columns of data, those being
> Path Name, Module Name and percent complete of the module.

Far too much code for me to take the time to read and understand it.

Suffice it to say that unless you are being paid by the hour ... I still can't understand the point of anything more than a simple:

SELECT .....
INTO x, y, z
FROM .......
WHERE ...... Then rather than using a function return the three values as OUT parameters from a stored proc.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)