Feature request: To display custom types correctly

[adderek]

This is a new feature request for the problem I can see in 7.1.5.1398. Probably could be exen classified as a bug.
I have some nasty code that is using custom types (objects defined as not final, then final versions and columns with such custom types - thus the table has "variable" number of columns). When I display table items in Oracle SQL Developer I can see at least all the items that are within a column along with the custom type name. In PL/SQL Developer I can see only the first item (thus I have no knowledge that such column contains anything more).
I could provide some more details (including DDL/SQL examples) if needed.

 

[Marco Kalter]

You mean for the Describe function? In the Object Browser you can already drill down to object attributes.

 

[adderek]

Query

SELECT col_1,col_2 FROM my_table;

would show:

col_1 col_2
-----------
    1     a
    2     b
    3     c

Where my col_1 is a NUMBER and col_2 is my_parent_type:

TYPE my_type UNDER my_parent_type
(first CHAR(1)
,second DATE
,third NUMBER
)

 

[adderek]

Additional problem:
While selecting the data on our production server I got ORA-30757 error displayed by the PL/SQL developer. And I just did

SELECT * FROM my_table;

in the SQL Window (so no data were displayed). This might be that my access rights are limited on production - but Oracle SQL Developer can execute this query and show me the results (ant it does it faster since it is fetching only N rows of data).