FOR rec in cursor_name LOOP
  return rec.count_column;
END LOOP;

return null;

OPEN cursor_name;
FETCH cursor_name INTO v_count;
CLOSE cursor_name;

RETURN v_count; 

my_count_var := MY_FUNCTION(some_parameter);

FUNCTION F_FUNCTION_NAME(p_param IN NUMBER) 
RETURN NUMBER IS
    
    CURSOR cursorname IS
    SELECT
       COUNT(*) COUNTS
    FROM
        dbo.remotename@remotelink rem,
        local_table_name ltn
      WHERE
          primary_key_column = p_param
          AND ltn.actual_date = rem."Date"
           AND ltn.div_division_number = rem."Garage_ID"
           AND ltn.block_number = rem."Run_Number"
           AND 'x' = (SELECT 'x' FROM dbo.remote_table_2@remotelink v where 
                v."Vehicle_Code" is not null and v.id = rem."Vehicle_ID");

BEGIN

    FOR rec IN cursorname LOOP
        RETURN rec.COUNTS ; 
    END LOOP;
    
    RETURN NULL;

END;