Selecting of object table using TOracleDataset

[his]

Hello,

When I activate TOracleDataset with the query like that 'select a.rowid, a.* from obj_table a' I got the oracle error 'ORA-03113' and my session closes. When I execute it without rowid everething is OK. That's wrong? How can I avoid this problem?

Thanks in advance,
Valeriy

 

[Marco Kalter]

Is there a user dump trace file that matches this error? If so, can you send it to me?

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

 

[his]

No, there is not

.
By the way, if I execute that query with rowid using TOracleQuery first and then execute it using TOracleDataset it works fine.
I examined upon Net 8 and Net 9, but results are the same. I use DOA 343 and Delphi 5.

I hope these tips will help you to understand what's wrong.

 

[Marco Kalter]

Strange. Can you do a TOracleQuery.Describe instead of an Execute and check if this fails as well?

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