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.
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_helperwasn't compile correctly.The compilation error occurs on the code below:
utPLSQL/source/expectations/data_values/ut_compound_data_helper.pkb
Lines 727 to 736 in e409664
This usage of
TABLE(local collection)is supported only on Oracle 12c and newer.