Problem with LOB's requiring OCI8 mode

Paul B

Member
I am using PL/SQL Developer 5.1.0.654 which shows usage of OCI: Version 8.1. On another machine, am using 5.1.4.729 which also shows usage of OCI: Version 8.1. Both of these machines are working against a local Oracle 9.2.0.4 Enterprise instance.

When performing a query that returns a CLOB, I receive the following PL/SQL Developer error message: "A query with LOB's requires OCI8 mode, but OCI7 mode is used."

I attempted to change the "Force OCI7 mode on OCI8" preference (Tools > Preferences > Options tab page) and restart the application, but either set or unset, I still received the error.
Any ideas?
 
If I'm not mistaken this can only happen if the "Force OCI7 on OCI8 mode" preference is set, but you mention that this does not matter.

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?
 
Back
Top