How to call to procedure without Cursor giving me a Statement Handle Error?

[Sally Madeira]

I have a a Procedure that invokes another procedure that returns a cursor. When I get to the FETCH Statement I get the following Error:

ORA-24338: statement handle not executed
ORA-06512: at "DATATRAN.PRC_STATASCIREPORT", line 31
ORA-06512: at line 2

It is something probably so simple but I have been struggling with this for quit sometime so now I am reaching out for help.
Thanks
S

CREATE OR REPLACE PROCEDURE datatran.prc_statascireport
AS
cur_time VARCHAR2 (10) := TO_CHAR (SYSDATE, 'HH12:MI:SS');
ERROR_CODE NUMBER;
error_msg VARCHAR2 (300);
sql_stm VARCHAR2 (1000);
refcsr sys_refcursor;
 
TYPE recorg IS RECORD (
idnumber VARCHAR2 (3 BYTE),
loanofficer1 VARCHAR2 (3 BYTE),
loanofficer2 VARCHAR2 (3 BYTE),
loannum VARCHAR2 (5 BYTE),
billcycle VARCHAR2 (1 BYTE),
accrint NUMBER,
earnstatus VARCHAR2 (1 BYTE),
nonearningtype VARCHAR2 (3 BYTE),
accrfloat NUMBER,
futureddacharge NUMBER,
accrfees NUMBER,
earnstatus1 VARCHAR2 (1 BYTE)
);
 
TYPE taborg IS TABLE OF recorg;
 
ltab taborg;
BEGIN
nela.pkg_aiagerp.sp_get_aiagerptdata@stnelapd ('A00', 'ZZZ', refcsr);
 
LOOP
FETCH refcsr
BULK COLLECT INTO ltab;
 
FOR i IN 1 .. ltab.COUNT
LOOP
DBMS_OUTPUT.put_line (ltab(i).idnumber);
END LOOP;
END LOOP;
 
END;

[amitpatel66]

You cannot use a REF CURSOR that way by invoking a procedure remotely using a DBLINK.

Check Restrictions on Cursor Variables