Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )

[redhair]

Hi ODAC Support Team,

My installed components:
- ODAC 9.4.14 for RAD Studio XE7
- C++ Builder XE 7 with Update 1
- Oracle 8i ( 8.1.7.4.0 ) Enterprise Edition
- Simple project: 1 OraSession ,1 OraQuery --> Direct Mode
( Installed Oracle Client : 11.0.2 64 bit Admin )
- Query :

Code: Select all

SELECT * FROM ALL_TAB_COLUMNS

If i try to query the table ALL_TAB_COLUMNS on a Oracle8i - database, i get an access violation "c0000005 ACCESS VIOLATION".
On other Oracle database versions ( 10g,11g,12c ) all works fine.

The problem only occurs, if i include the column DATA_DEFAULT (LONG-Datatype) in the query.

Code: Select all

SELECT DEFAULT_LENGTH,DATA_DEFAULT FROM ALL_TAB_COLUMNS

Thank you

[AlexP]

Hello,

Thank you for the sample. We have reproduced the described case and will investigate the reason for such behavior. We will inform you as soon as we have any results.

[AlexP]

We have already fixed the problem. The fix will be included into the next version.

[redhair]

Thank you

[AlexP]

If you have any further questions, feel free to contact us.

[ysyang]

I have the same problem.

[ysyang]

Can i get the fixed code ?

[AlexP]

Please send me (to alexp*devart*com) the license number and an e-mail address where I can send you the fixed version, also specify the used IDE.

[ysyang]

I sent email to you

[AlexP]

Your subscription expired. For access to the latest version, you should renew the subscription at our website: http://www.devart.com/odac/ordering.html .

[ysyang]

I buy subscription.

[AlexP]

I have answered you via email.

[ysyang]

It works fine.
Thank you.

[AlexP]

You are welcome. Feel free to contact us if you have any further questions.