Page 1 of 1
Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Thu 22 Jan 2015 16:31
by 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 :
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
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Mon 26 Jan 2015 11:52
by 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.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Mon 23 Feb 2015 07:41
by AlexP
We have already fixed the problem. The fix will be included into the next version.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Tue 24 Feb 2015 16:33
by redhair
Thank you
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Wed 25 Feb 2015 09:49
by AlexP
If you have any further questions, feel free to contact us.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Fri 06 Mar 2015 02:59
by ysyang
I have the same problem.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Fri 06 Mar 2015 05:31
by ysyang
Can i get the fixed code ?
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Fri 06 Mar 2015 08:28
by 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.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Mon 09 Mar 2015 09:31
by ysyang
I sent email to you
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Tue 10 Mar 2015 09:57
by 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 .
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Wed 11 Mar 2015 04:11
by ysyang
I buy subscription.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Wed 11 Mar 2015 11:49
by AlexP
I have answered you via email.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Thu 12 Mar 2015 00:18
by ysyang
It works fine.
Thank you.
Re: Access Violation during query on table ALL_TAB_COLUMNS ( Oracle8i )
Posted: Thu 12 Mar 2015 05:33
by AlexP
You are welcome. Feel free to contact us if you have any further questions.