Application Error when selecting an Object Array in SQL or Test Window

[Gordon Heimann]

Whenever I try to select from a Table, that contains an Array Object, the whole PL/SQL Developer is crashing.
I am using Window Vista, but some Colleagues, are having the same problem using Windows 7.

PL/SQL Version is 8.0.2.1505 and we are on Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
Maybe you have an idea about this?

To give you an example, I created a Testcase:

-- create an object
CREATE OR REPLACE TYPE GH_TEST_OBJ IS OBJECT
( col1 VARCHAR2(1000),
col2 VARCHAR2(1000));

-- create an array
CREATE OR REPLACE TYPE GH_TEST_ARR
IS VARRAY(1000) OF GH_TEST_OBJ;

-- Create a table
create table GH_TEST
( ID NUMBER not null,
TEST_ARR GH_TEST_ARR);

-- insert a record into the table
DECLARE
l_array GH_TEST_ARR;
BEGIN
l_array := GH_TEST_ARR();
l_array.extend(1);
insert into gh_test VALUES
(1,l_array);
END;

--selecting from the table will cause PL/SQL Developer to crash:
SELECT * FROM GH_TEST a

Kind Regards,
Gordon Heimann

 

[Marco Kalter]

This is most likely an Oracle Client version issue. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?