ORA-01041: internal error hostdef extension doesn't exist

[DonnaNewman]

I am trying to query data using pl/sql developet and am receiving the following error:

ORA-01041: internal error hostdef extension doesn't exist

I have disabled the Debug option in found in:

Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option,

Problem persists.

Can someone please help - this error is doing my head in. Thank you.

 

[DonnaNewman]

P.s. Output from help>about is:

PL/SQL Developer
Version 7.0.0.1050 (MBCS)
02.26113 - Unlimited user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Physical memory : 515,440 kB (50,940 available)
Paging file : 1,254,996 kB (151,448 available)
Virtual memory : 2,097,024 kB (1,985,068 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
11DBA
11DEV
11DEV2
11DEVT
11MSTR
...

Homes
ADI_HOME (C:\ADI_HOME\)
BI_HOME (C:\BI_HOME)
ORA92 (C:\ORACLE)

DLLs
C:\ADI_HOME\bin\oci.dll
C:\ADI_HOME\bin\ORA73.DLL
C:\ADI_HOME\bin\ORA803.DLL
C:\ADI_HOME\bin\ORA804.DLL
C:\ADI_HOME\bin\ORA805.DLL

TNS File
C:\tnsarea\tnsnames.ora

Using
Home: ADI_HOME
DLL: C:\ADI_HOME\bin\oci.dll
OCI: Version 8.0
Oracle9i Enterprise Edition Release 9.2.0.8.0
Character size: 3 byte(s)

 

[Marco Kalter]

I notice you have 3 Oracle Homes:

- ADI_HOME (C:\ADI_HOME\)
- BI_HOME (C:\BI_HOME)
- ORA92 (C:\ORACLE)

Can you start PL/SQL Developer, go to Tools > Preferences > Options tab page, select "ORA92" from the Oracle Home selection list, restart PL/SQL Developer, and try again?

Let me know how this turns out.