nested collections in sql window crashes entire application

[Shaun]

If you try to view a collection within a collection in a sql query it seems to crash PlsqlDeveloper. I've been able to reproduce in multiple versions including 12.0.7.1837.

CREATE TABLE TEST_UDT_TABLE (top top_level_type);

CREATE TYPE lowest_level_type AS OBJECT (
id number
);
CREATE TYPE lower_level_type as VARRAY(100) of lowest_level_type;

CREATE TYPE mid_level_type AS OBJECT ( low lower_level_type );
);
/

CREATE TYPE top_level_type AS VARRAY(100) OF mid_level_type;
/

CREATE TABLE TEST_UDT_TABLE (top top_level_type);

insert into test_udt_table values (TOP_LEVEL_TYPE(MID_LEVEL_TYPE(LOWER_LEVEL_TYPE(LOWEST_LEVEL_TYPE(1)))));

select low.id from test_udt_table t,
TABLE(top) top,
TABLE(low) low;
-- this works

select * from test_udt_table;
-- open TOP
-- open LOW
-- ** crash **

Thanks

 

[Marco Kalter]

This may be an Oracle Client version issue. Can you start PL/SQL Developer, go to Help > Support Info copy the text from the "Info" tab page?

 

[Shaun]

PL/SQL Developer
Version 12.0.7.1837 (64 bit)
13.106831 - Unlimited user license
Service Contract: 4/1/2017
Windows 7 Build 7601 (Service Pack 1)

Physical memory : 4,193,784 kB (2,327,820 available)
Paging file : 8,385,668 kB (6,391,388 available)
Virtual memory : 8,589,934,464 kB (8,589,543,932 available)

Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer 12\Preferences\Default\Default.ini
C:\Users\user\AppData\Roaming\PLSQL Developer 12\Preferences\user\default.ini
C:\Users\user\AppData\Roaming\PLSQL Developer 12\Preferences\user\New.ini

License File
C:\Program Files\PLSQL Developer 12\aalf.dat

Debug file
C:\Users\user\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
XYZ
...

Homes
OraClient11g_home1 (C:\app\user\product\11.2.0\client_1)

DLLs
C:\app\user\product\11.2.0\client_1\bin\oci.dll

TNS File
C:\app\user\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\app\user\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1 (11.2.0.1.0)
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Process
Working Set = 169,762,816
Memory = 50,989,120
GDI Objects = 756
User Objects = 778
Handles = 555

 

[Shaun]

Thank you Marco, I believe you are correct. I updated to instant client 12.2.0.1 and it seems to be working now.