Print Thread
Trouble with BLOB on Oracle XE 23c
#64569 04/27/23 06:20 PM
Joined: May 2005
Posts: 30
Member
OP Offline
Member
Joined: May 2005
Posts: 30
Hello,

Trying the new Oracle XE database, DOA 4.1.3.5 and Delphy 10.4 Sydney (update 2) - cannot open a dataset when there is a LOB field:

Exception with message: "A query with LOB's requires OCI8 mode, but OCI7 mode is used."

But I did not set OCI7, it is false on OracleSession. Same querys runs OK against Oracle XE 18c or Oracle 19.x

Re: Trouble with BLOB on Oracle XE 23c
Tailor K #64570 04/27/23 08:11 PM
Joined: May 2005
Posts: 30
Member
OP Offline
Member
Joined: May 2005
Posts: 30
I had found a similar problem on Oracle 21 - using DOA 4.1.4 solved the inital problem - this can be closed.


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.077s Queries: 15 (0.011s) Memory: 2.4964 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-27 14:35:46 UTC
Valid HTML 5 and Valid CSS