Temporary TLOBLocator requires Net8 8.1 or later

[BZerbe]

When trying to view the Explain Plan for a query, the following error message arises:

A Temporary TLOBLocator requires Net8 8.1 or later

After clicking Ok to the error message, the Explain Plan does show. How do I prevent this error message from popping up?

When I go to Help --> Check Online Updates, everything shows with a status of OK. So if I need to update something, what would I update and how?

PLD: 11.0.4.1774

 

[Marco Kalter]

This indicates that PL/SQL Developer is using an Oracle 8.0 Client (or earlier).

If you have multiple Oracle Clients installed, you can go to Tools > Preferences > Oracle / Connection to select a more recent version from the "Oracle Home" selection list.

If you don't have a more recent Oracle Client installation you will need to upgrade your current Oracle Client.

If you are not sure, go to Help > Support Info and send me the information from the "Info" tab page.

 

[BZerbe]

Thanks Marco. I will try it out. My current client version is < 8.

 

[William Robertson]

Wow. Oracle 8.0 came out in 1997. Are you saying your client version is 20 years old?

 

[BZerbe]

Unfortunately, I am. We use Oracle Forms 6i and PLD must be using the client that gets installed with Oracle Forms 6i.

So, I just installed the Oracle SQL Plus Instant Client 11.2.0.4.0 in the c:\instantclient_11_2 directory. I then went to PLD --> Preferences --> Connection. I then pasted this directory in the Oracle Home and OCI Library properties because I want PLD to look at the new version. But, when I try to connect to the database I receive the following error:

Initialization error
Could not load "c:\instantclient_11_2"

OCIDLL forced to c:\instantclient_11_2
LoadLibrary(c:\instantclient_11_2) returned 0

 

[Marco Kalter]

Is this perhaps a 64 Bit Oracle Client? You will need a 32 Bit version.

 

[BZerbe]

32 Bit client.

 

[Worker]

Are you sure c:\instantclient_11_2\oci.dll exists? No typos?

What happens when you use Start->Run
"c:\Program Files (x86)\PLSQL Developer\plsqldev.exe" instantclient="c:\instantclient_11_2"

 

[BZerbe]

Yes, c:\instantclient_11_2\oci.dll exists without any typos. I have double checked this and the error message persists.

If I use Start --> Run
"c:\Program Files\PLSQL Developer\plsqldev.exe" instantclient="c:\instantclient_11_2"
Then it works correctly and I can connect to the database. Everything looks fine when using this method. (I have a 32bit Win7 machine)

 

[Worker]

I think I had the same problem (which is why I use the command-line parameter) but I blamed it on also using the "nologon" command-line parameter.

I'm glad you got it working. I'll leave any remaining bug-hunting to Marco

 

[BZerbe]

Yea, thanks a lot Worker!

I will just leave the preferences for Oracle Home and OCI Library blank and use the command line parameters like you suggested.