SQL & PL/SQL

hi

I am having a reference cursor in one procedure.I am fetching it from another package.I want to return a cursor to java code but in logs i am getting error
java.sql.SQLException: Ref cursor is invalid

and in pl/sql developer it is giving ORA-24338 error .Please help

CREATE OR REPLACE PACKAGE BODY pk_ext_eod_bcind_static_data AS
var_l_ret_cod NUMBER;

FUNCTION ap_ext_eod_bcind_static_data(cursname_1 OUT pk_ext_eod_bcind_static_data.cursname) RETURN NUMBER AS

l_cursor pk_ext_eod_bcind_static_data.cursname;
tmp_cursor l_cursor%rowtype;
{
{
ap_ext_eod_static_data(var_l_dat_last_process,l_cursor);
LOOP
FETCH l_cursor INTO tmp_cursor;

EXIT WHEN l_cursor%NOTFOUND;
END LOOP;
CLOSE l_cursor;

RETURN SUCCESS;
EXCEPTION
WHEN OTHERS THEN
RAISERROR(SQLCODE,'Error in Call to ap_ext_eod_static_data');
}

}
END;