I noticed when I have more than one sys_refcursor as an output parameter I receive an error ORA-06504: PL/SQL: Return types of Result Set variables or query do not match. I attemted to assure the number of rows returned was >= 0 (# >= and 0). Is this a known bug? If not, what other suggestions do you have to verify this stored procedure?
Thank you for your assistance.