FUNCTION get_foo IS
 l_cursor SYS_REFCURSOR := NULL;
BEGIN
 OPEN l_cursor FOR
  SELECT bar, baz
  FROM foo_table;
 
 RETURN l_cursor;
END get_foo;