collection items in SQLWindow

[clx]

Hi,
We currently evaluate the latest PLSQLDeveloper Version (7.0.2.1076) for a big customer. The challenge here is a very complex and deep object/nested table hierarchy. So far we found some points making the daily development a little bit more difficult. Hier one short sample:

-- type t_element
create or replace type t_element as object
(
  -- Attributes
  l_key          integer,
  l_value        varchar2(100)
);

-- nested table t_element_nt
create or replace type t_element_nt as table of t_element;

-- type t_tecdata
create or replace type t_tecdata as object
(
  l_datadesc varchar2(30),
  l_dataelem t_element_nt
);

-- table with colum of type t_tecdata
CREATE TABLE TESTPSD
(
	TEC_ID NUMBER(8,0) NOT NULL ENABLE,
	TEC_DESC VARCHAR2(50),
TEC_DATA T_TECDATA
)
NESTED TABLE TEC_DATA.L_DATAELEM STORE AS NT_TEC_DATA RETURN AS VALUE;

-- sample data
insert into testpsd(tec_id, tec_desc, tec_data)
values
(
1, 'Test XYZ', t_tecdata('Testdata',t_element_nt(t_element(100,'Testvalue')))
)

Our problems so far:

• 1 SQL-Window does not show the collection elements when using e.g.

 

[Marco Kalter]

1 SQL-Window does not show the collection elements when using e.g.