oci.dll problems

[chriso]

Hi All,

I have installed Oracle 10g on vista 64 bit. I have also installed PL/SQL developer (v 7.1.5) on the same machine. When i try to log into an oracle instance, it says that it could not load the oci.dll file - it shows me the path and it IS there, so I assuming its something to do with PL/SQL developer being 32bit and Oracle 10g 64 bit? if this is the case, how can I fix it? Is there a 64 bit version of PL/SQL developer? I have tried loading oracle 32 bit but it has problems as is not certified for vista 64 bit.

any ideas? Thanks

 

[Marco Kalter]

You will need to install a 32 Bit Oracle Client. PL/SQL Developer is a 32 Bit application, so it cannot interface with a 64 Bit Oracle Client.

The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary.

 

[Michael5528]

I also ran into this problem, running the 64 bit Oracle 10g Rev 2. I installed the 32-bit client and tried to enter the oci.dll location for this client in the Preferences... as C:\oracle\product\10.2.0\client_1\oci.dll, but after closing PLSDev and reopening, the login reverts to the 64 bit OCI library and I get the same error. Same thing if I set Preferences to use ociw32.dll.

Any ideas?

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Michael5528]

I sent the information in an email. Have you received it?

 

[Marco Kalter]

I don't think so. Where did you send it?

 

[Michael5528]

I did an Email post, but I have sent it again this morning to support@allroundautomations.com.

 

[Suhas]

I have PL SQL developer version 7.1.5.1398. Recently we upgraded to 11g. When I execute the package in test window and then try to open the output cursor I am getting this error : Access Violation at address 604966B in module OraClient8.dll Read of address 00000000
What is the reason for this error?

 

[Marco Kalter]

I have PL SQL developer version 7.1.5.1398. Recently we upgraded to 11g...

Please create a separate topic for problems that do not relate to this topic.

 

[Suhas]

Hi Marco,
I have created a new topic.

Thanks,
Suhas