OCI8 mode required, but OCI7 mode used on query using Oracle 21c - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer OCI8 mode required, but OCI7 mode used on query using Oracle 21c

Print Thread

OCI8 mode required, but OCI7 mode used on query using Oracle 21c #62357 01/30/21 10:24 PM
Joined: Jan 2021 Posts: 3 A AngelS OP Member
OP AngelS Member A Joined: Jan 2021 Posts: 3	After migrating to Oracle 21c,my PL/SQL Version 13.0.6.1911 (64 bit) refuses to execute a query that worked fine on 12c,18c and 19c. ##'A query with objects requires OCI8 mode but OCI7 mode is used"## ## Preferences: Use OCI7: False ## This happens with InstantClient 12.2 and 19.1 64 bits Clients.

Re: OCI8 mode required, but OCI7 mode used on query using Oracle 21c AngelS #62360 02/01/21 09:26 AM
Joined: Aug 1999 Posts: 22,210 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,210	Can you connect to the database, go to Help > Support Info, and send the text from the "Info" tab page to support@allroundautomations.com? Marco Kalter Allround Automations

Re: OCI8 mode required, but OCI7 mode used on query using Oracle 21c AngelS #62363 02/01/21 12:03 PM
Joined: Jan 2021 Posts: 3 A AngelS OP Member
OP AngelS Member A Joined: Jan 2021 Posts: 3	Hi Marco, I've sent the e-mail to your appreciation.

Re: OCI8 mode required, but OCI7 mode used on query using Oracle 21c AngelS #62364 02/01/21 02:13 PM
Joined: Jan 2021 Posts: 3 A AngelS OP Member
OP AngelS Member A Joined: Jan 2021 Posts: 3	Fix sent resolved the issue.

Re: OCI8 mode required, but OCI7 mode used on query using Oracle 21c AngelS #62368 02/02/21 09:35 AM
Joined: Aug 1999 Posts: 22,210 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,210	Thanks for confirming! Marco Kalter Allround Automations

Re: OCI8 mode required, but OCI7 mode used on query using Oracle 21c AngelS #62805 12/19/21 07:14 PM
Joined: Mar 2010 Posts: 14 H hollowb7 Member
hollowb7 Member H Joined: Mar 2010 Posts: 14	Like to ge the fix as well as we face the same issue with 21c. DOA 4.1.3.5 for Delphi RIO.

Re: OCI8 mode required, but OCI7 mode used on query using Oracle 21c AngelS #62806 12/20/21 10:14 AM
Joined: Aug 1999 Posts: 22,210 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,210	Wrong forum, but we'll have a Direct Oracle Access 4.1.4 patch available for this shortly. Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.137s Queries: 15 (0.047s) Memory: 2.5182 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-06 14:43:25 UTC
Valid HTML 5 and Valid CSS