-
Notifications
You must be signed in to change notification settings - Fork 187
Closed
Description
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:
utPLSQL/source/expectations/data_values/ut_compound_data_helper.pkb
Lines 727 to 736 in e409664
| 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.
Reactions are currently unavailable