ORA-03113 on TOracleDataSet.Open with object-based table

[Roald Andresen]

I have a table definition looking like this:
create or replace type T2 as object
(
C2 varchar2(30),
N2 number
);
create or replace type T1 as object
(
C1 varchar2(10),
N1 number,
O1 T2
);
create table testtab of T1;

Furthermore, I have a TOracleDataSet object DS with sql:
"select t.*, t.rowid from testtab t"

When calling DS.Open, I get ORA-03113.

The database is fine. No errors in the SQL trace. The TOracleSession object looses its connection with the database, but can easily connect again immideately afterwards.

I'm running Oracle 9.2.0.1.0 and DOA 3.4.6.3.

Kind regards,
Roald

 

[Marco Kalter]

This is probably an Oracle Net or Oracle Server bug.

ORA-03113 usually means that the Oracle Server process for the current session has crashed. Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03113 error? Usually you will see an ORA-00600 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me?

------------------
Marco Kalter
Allround Automations

 

[Roald Andresen]

Files have been mailed.

Roald

 

[Marco Kalter]

It may be that you are running into Oracle bug 2476147. To verify this, can you run the same query in SQL*Plus, from the Primary Oracle Home that Direct Oracle Access is using?

------------------
Marco Kalter
Allround Automations

 

[Roald Andresen]

I'll check out the Oracle bug. I have also found a report on Metalink giving me some points to check out. However, it might take a couple of days before I have the time. I'll get back with the results then.

Roald