create or replace function get_param_value(p_param_name in varchar2) return varchar2 as
--   v_rest_host varchar2(200) := 'http://crldev.tecna.pl:8078';
   v_rest_host varchar2(200) := 'http://192.168.1.103:8078';
 --     v_rest_host varchar2(200) := 'http://192.168.1.20:8078';
--   v_rest_host varchar2(200) := 'http://windev.tecna.pl:8078';
begin
  case lower(p_param_name)
     when 'url_rest' then return v_rest_host || '/rest/api';
     when 'url_dic_rest' then return v_rest_host || '/rest/api/Dictionaries';
     when 'url_contr_rest' then return v_rest_host || '/rest/api/Contractors';
     when 'url_inv_rest' then return v_rest_host || '/rest/api/Invoices';
     when 'nip24_key_id' then return 'test_id';
     when 'nip24_key' then return 'test_key';
     when 'nip24_api_url' then return 'https://www.nip24.pl/api-test';
     else  return null;
  end case;
end get_param_value;