PL/SQL error while querying BLOBs. "A query with LOB's require OCI8 mode, but OCI7 mode is used"

Question

I have a table where there is a column defined as BLOB. When i try to query the table, i am not able to view anything and a message is displayed saying "A query with LOB's require OCI8 mode, but OCI7 mode is used". I have unchecked the box "Force OCi7 mode on OCI8", saved and restarted PL/SQL developer and still the error persists. I am using PL/SQL version 5.1.3.704 and OCI: Version 8.1.

Can someone please help?

Niharika Upadhyay · Accepted Answer · 2016-12-14 07:55:12Z

1

You need to Upgrade to the current version for Oracle.

This version can be downloaded by going to: https://support.quest.com/SUPPORT/index?page=downloads.

Hope this helps.

answered Dec 14, 2016 at 7:55

Niharika Upadhyay

1081 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ram Over a year ago

So is there no other way apart from upgrade, inorder to view the data?

Ranjit Over a year ago

@NiharikaUpadhyay Are you in LinkedIn

Collectives™ on Stack Overflow

PL/SQL error while querying BLOBs. "A query with LOB's require OCI8 mode, but OCI7 mode is used"

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related