10G: Query with LOB's failed

[Roald Andresen]

I have just upgraded both my oracle client and server from 9.2.0.4 to 10GR1.
Both my applications and PL/SQL Dev. fails with the following error:

"A Query with LOB's requires OCI8 mode, but OCI7 mode is used."

In my app. TOracleSession.Preferences.UseOCI7 is set to false.

DOA version: 4.0.3
PL/SQL Dev. ver.: 5.1.4.730

Help...

Btw.: Could you please email my product code to me - I seem to have lost it?

Roald Andresen

 

[Marco Kalter]

You will need to download the current 4.0.5 release for 10g compatibility.

I have sent you your product code by e-mail.

 

[Roald Andresen]

Thanks Marco.

I have upgraded DOA, and my appl works fine.

I have also upgraded PL/SQL Dev. til 5.1.6.747, but there I still get the same error.

This should probably be in the PL/SQL forum now, but...

Roald

 

[Marco Kalter]

For the PL/SQL Developer problem: 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?

 

[Roald Andresen]

Case solved.
The Help->About->Info showed me the problem.
For some reason, an older oci.dll had found its way into my c:\windows directory, and thus was picked up by pl/sql dev as default.
Deleting that caused the correct dll to be pick up, and everything works just fine.

Roald