declare
  P_ORGANIZATION_CODE varchar2(240);
   a SYS_REFCURSOR;
  TYPE empd IS TABLE of hope.hope_forecast_data%ROWTYPE;
  empdet empd;
begin
  open a for select * from hope.hope_forecast_data
  WHERE ORGANIZATION_CODE=: P_ORGANIZATION_CODE;
  FETCH a BULK COLLECT INTO empdet;
  DBMS_OUTPUT.PUT_LINE('Organisation code:'|| '  '|| empdet.ORGANIZATION_CODE);
end;

SQL> set serveroutput on;
SQL> 
SQL> DECLARE
  2     P_ORGANIZATION_CODE VARCHAR2(240);
  3     A                   SYS_REFCURSOR;
  4     TYPE EMPD IS TABLE OF HOPE_FORECAST_DATA%ROWTYPE;
  5     EMPDET EMPD;
  6  BEGIN
  7     OPEN A FOR
  8        SELECT * FROM HOPE_FORECAST_DATA WHERE ORGANIZATION_CODE = 'abcd';
  9     FETCH A BULK COLLECT
 10        INTO EMPDET;
 11     FOR I IN 1 .. EMPDET.COUNT LOOP
 12        DBMS_OUTPUT.PUT_LINE('Organisation code:' || '  ' || EMPDET(I)
 13                             .ORGANIZATION_CODE);
 14     END LOOP;
 15  END;
 16  /
 
Organisation code:  abcd
Organisation code:  abcd
Organisation code:  abcd
Organisation code:  abcd
Organisation code:  abcd
 
PL/SQL procedure successfully completed