I'm running TOAD 8.0.0.47 and I don't see the 'Load into grid from memory (strong and weak)' option. When I click the print DBMS output or the Create and Write to table option I get an error.
The procedure executes fine in SQL PLUS but I can't get it to execute using TOAD. I get the following error in the second declare statement below: Error: PLS-00320: the declaration of the type of this expression is incomplete or malformed
DECLARE
SAL_WKS UPK_GET_SALARY_AVAIL_WEEKS.ref_cursor;
SAL_WKS_row SAL_WKS%ROWTYPE;

Everything is spelled correctly and so I'm not sure why I would be getting that error.. The UPK_GET_SALARY_AVAIL_WEEKS create statement is:

CREATE OR REPLACE PACKAGE UPK_GET_SALARY_AVAIL_WEEKS IS
TYPE ref_cursor IS REF CURSOR;
PROCEDURE USP_C_TMWKSL_GET_SAL_WEEKS_SEL ( I_EMP_NUM VARCHAR2,
I_EMP_ROLE VARCHAR2, SAL_WKS OUT ref_cursor );

I'm quite confused...