create table test_customers(name varchar2(32));

--

insert into test_customers (name) values ('Ali-Baba');
insert into test_customers (name) values ('Aladdin');
insert into test_customers (name) values ('Al de Baran');

--

create or replace package TEST_PCK is

  function searchItem(p_name in varchar2) return varchar2;
  
  function getItems return sys.odcivarchar2list;

end TEST_PCK;

--

create or replace package body TEST_PCK is

  local_storage_result sys.odcivarchar2list;

  function searchItem(p_name in varchar2) return varchar2 is
  begin

    select p_name||'='||level
    bulk collect into local_storage_result
    from dual
    connect by level <= 5;
    
    return p_name;
    
  end;
  
  function getItems return sys.odcivarchar2list is
  begin
    return local_storage_result;
  end;

end TEST_PCK;

--

create or replace view test_terrorist_vw as select column_value as column_value from table(test_pck.getItems());