Compilation error in ut_compound_data_helper

felipebz

Hi!

I just tried to install the new utPLSQL v3.1.7 on Oracle Database 11.2.0.4.0 and I noticed the package ut_compound_data_helper wasn't compile correctly.

The compilation error occurs on the code below:

	function get_json_diffs_type(a_diffs_all tt_json_diff_tab) return tt_json_diff_type_tab is
	l_diffs_summary tt_json_diff_type_tab := tt_json_diff_type_tab();
	begin
	select d.difference_type,count(1)
	bulk collect into l_diffs_summary
	from table(a_diffs_all) d
	group by d.difference_type;

	return l_diffs_summary;
	end;

Errors for PACKAGE BODY TESTES.UT_COMPOUND_DATA_HELPER:

LINE/COL ERROR
-------- -----------------------------------------------------------------
730/5    PL/SQL: SQL Statement ignored
732/10   PL/SQL: ORA-22905: cannot access rows from a non-nested table item
732/16   PLS-00642: local collection types not allowed in SQL statements
--------------------------------------------------------------

This usage of TABLE(local collection) is supported only on Oracle 12c and newer.