DBMS Scheduler error: "ORA-03115: unsupported network datatype or representation"

[Patrick Holmes]

I switched from using a 32-bit WinXP to using a 64-bit Win7 computer, yesterday. Everything I've used so far in PL/SQL Developer is working fine except: When I open the DBMS Scheduler tool and then click on the "Running Jobs", "Jobs" and "Chains" folders in the tool's tree ("Job Runs", "Running Jobs", "Jobs", "Chains", etc.), I get the following Oracle error:
ORA-03115: unsupported network datatype or representation

Does PL/SQL Developer run properly in 64-bit Win7? Is there some setting that I need to change to get this to work correctly?

Here is my support info:
PL/SQL Developer
Version 10.0.5.1710
01.96233 - 5 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,777,956 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files x86\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\pat\AppData\Roaming\PLSQL Developer\Preferences\pat\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files x86\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files x86\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files x86\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files x86\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
archdb
dlp
EXTDB
LAD
ORCL
...

Homes
DEFAULT_HOME (C:\orant)

DLLs
C:\orant\bin\oci.dll
C:\orant\bin\ORA803.DLL
C:\orant\bin\ORA804.DLL
C:\orant\bin\ora805.dll

TNS File
C:\OraInst32\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\orant\bin\oci.dll
OCI: Version 8.0
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16

thanks,
pat holmes

 

[Marco Kalter]

You will need to install a (32 bit) Oracle11g or 12c Client. Your current Oracle 8.0.5 Client is incompatible with the scheduler data types.