TYPE varchar2_array_type IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;In package body:
ze_or_keys varchar2_array_type; BEGIN FOR i in 1 .. ze_or_keys.count LOOP IF i != 1 THEN my_string := my_string || ' OR '; END IF; my_string := my_string || ze_or_keys(i) || '=''' || ze_or_values(i) || ''''; END LOOP; END;