Need help returning TABLE from Oracle function

CREATE OR REPLACE
FUNCTION test_warn3

RETURN VARCHAR2 IS ERRORS ab_curs.error_list;
startdate DATE := to_date('01-JAN-2009','DD-MON-YYYY'); enddate DATE := to_date('31-JAN-2009','DD-MON-YYYY'); histdate DATE := TRUNC(SYSDATE);

BEGIN update_package1.update_query(errors,

                               startdate,
                               enddate,
                               histdate);

RETURN('Test Warn 3 Complete');

END; -- END FUNCTION test_warn3
/

However, what I really want to do is return ERRORS, NOT just the message 'Test Warn 3 Complete', and then take the results of errors and do some logic in C#. However, I haven't been able to get this to work - I've tried having an OUT param that's a REF CURSOR and doing:

OPEN errorCursor FOR SELECT * FROM ERRORS, but I get an error when I try to run that because the compiler doesn't recognize ERRORS as a table in the database - it isn't. It's just a TABLE return type.

Any help appreciated,

Bryan Received on Mon Mar 30 2009 - 15:12:06 CDT