Re: Returning data from temp_tables

I am reading as carefully as possible. Possibly there is something wrong with the package definition but I still get an error trying to open this NESTED cursor the way you say should work.

CREATE OR REPLACE PACKAGE PKG_DASHBOARD AS   TYPE ref_cur is ref cursor RETURN result_master%ROWTYPE; -- won't take SYS_REFCURSOR
  Procedure list_mailable(MAILLIST OUT ref_cur);

END PKG_DASHBOARD;
/

CREATE OR REPLACE PACKAGE BODY PKG_DASHBOARD AS PROCEDURE list_mailable(maillist OUT ref_cur) IS

   OPEN maillist FOR 'SELECT * FROM result_master A WHERE labno = :1 and a.labno in(select labno from sample_demog_master where link in(select link

    from sample_demog_master where labno=link))' USING c1rec;     LOOP
    FETCH maillist INTO c3rec;
    EXIT WHEN maillist%NOTFOUND;

PLS-00455: cursor 'MAILLIST' cannot be used in dynamic SQL OPEN statement Received on Mon Aug 06 2007 - 07:54:43 CDT