Skip to content

Compilation error in ut_compound_data_helper #947

New issue
New issue
Closed
#948
Closed
Compilation error in ut_compound_data_helper#947
#948
Labels
bug
Milestone
 
v3.1.8
@felipebz

Description

@felipebz
felipebz
opened on Jun 18, 2019

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bug

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions