If a user tries to execute a package from the Procedure Editor, which contains a SYS_REFCURSOR parameter, it fails with the following errors:
ORA-06550, PLS-00302
For example:
CREATE OR REPLACE PACKAGE pkg_sys_refcursor IS
PROCEDURE prc_sys_refcursor
(io_refcur IN OUT SYS_REFCURSOR);
END;
/
CREATE OR REPLACE PACKAGE BODY pkg_sys_refcursor IS
PROCEDURE prc_sys_refcursor
(io_refcur IN OUT SYS_REFCURSOR) IS
BEGIN
NULL;
END;
END;
/
WORKAROUND
Toad malforms the anonymous block. Look at the declare section under set parameters and remove the package prefix on the SYS_REFCURSOR. Ok the changes and execute the package.
STATUS
This issue was fixed in Toad for Oracle 8.6.0.38. The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp.
