create or replace function get_text(p_id t1.id%type)
return varchar2
is
  type my_type_cur is ref cursor;
  v_curs my_type_cur;
  v_text t1.text%type;
begin
  open v_curs for
    select text from t1 where id = p_id;

  fetch v_curs into v_text;

  close v_curs;

  return v_text;
end;
/