Can't get UDF to work

I'm trying to get the following udf to work but I get an error on "into u_tasks" on the second line of the query. Does anyone know how I can get around this error. I've tried a bunch of different ways to accomplish this result and it seems like this would be the cleanest approach ... if I could get it to work.

function getPercentDone( u_uid in number, c_uid in number ) return number is
the_percent number(10);
ttl_tasks number(10);
u_tasks number(10);
begin

    select count(att.task_uid) into ttl_tasks,     count(ug.start_date) into u_tasks
    from all_tasks att, user_grade ug
    where att.class_uid = c_uid
    and att.task_uid = ug.task_uid(+)
    and ug.user_uid(+) = u_uid;

    the_percent := (u_tasks/ttl_tasks) * 100;     return ( the_percent );
end getPercentDone;

Thanks for your help!
Brian Received on Sun Feb 10 2002 - 15:10:41 CET