Hi friends,



I am trying to do the following:



TYPE refcur IS REF CURSOR;



PROCEDURE myFunction(resultset OUT refcur)

IS

TYPE ids IS TABLE mytable.ids%TYPE;

Job_ids ids;

BEGIN

OPEN myFunction.resultset FOR 'select ids from mytable';

FETCH myFunction.resultset BULK COLLECT INTO Job_ids; <ERROR OCCURS
HERE>

END;



I obtain the following error when I run the procedure:

Error -6504: ORA-06504: PL/SQL: Return types of Result Set variables or
query do not match

ORA-06504: PL/SQL: Return types of Result Set variables or query do not
match

ORA-06512: at line 23

Program terminated with errors



Can anybody help with this. Using Oracle 9i



Regards,

Srinivas Shesham




Oracle LazyDBA home page