PL/SQL: effectively reusing table of object type in PL/SQL

Just follow the example code to get the feature. declare v_tbl ty_varchar2_tbl; — table of varchar2 v_stmt clob; g_te_merge_te ty_te; begin — here we fill our table one time select column_value bulk collect into v_tbl from table( pk_utils.vchar2_to_vchar2_lines( v_sd.composite_key, ‘,’ ) ) ; — some code follows — … — don’t try to get intricacies […]