Crash when selecting from PL/SQL Objects Types

[Dean Belshaw]

PL/SQL Developer SQL window crashes when selecting data from a table with a with a PL/SQL object type defintion.

E.g.
1) Table wf_out contains a column "USER_DATA" of pl/sql object type WF_EVENT_T

2) WF_EVENT_T has a column "Parameter_list" of object type WF_PARAMETERS_LIST_T

3) WF_PARAMETER_LIST_T is a variable array of the Object WF_PARAMETER_LIST

4) WF_PARAMETER LIST is a structure of two varchar2 variables.

Running the following statement crashes PL/SQL developer without an error. This works fine in SQL. This is a pretty common requirement for us Oracle Application Developers.

Select t.user_data.parameter_list from wf_out t

Version:
Oracle database 8.1.7.4
PL/SQL Developer 6.0.1.848

 

[Marco Kalter]

Could it be that you are using Oracle Net 8.0? Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Dean Belshaw]

I sent the details through as requested, any updates ?

 

[Marco Kalter]

According to the information you sent me, you are indeed using Oracle Net 8.0 from your "OraD6i" Home. If you go to Tools > Preferences > Oracle / Connection page, you can select a different Oracle Home to fix this.