Directpathloader and ORA-24329: invalid character set identifier

[Alvaro]

Hi:
Our Client changed their server 8.1.7 to 9
One of our software (a ETL tool) that uses Directpathloader is not working anymore. The rest of our software works OK.

ORA-24329: invalid character set identifier

DOA: 3.4.6.4
Client:
Windows 2000 Server
Oracle Net8

Server:
Oracle 9i v.9.2.0
Aix 5.2

Any simple way to fix,workaround?

 

[Alvaro]

More data:

Oracle server:
NLS_CHARACTERSET: WE81508859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Marco Kalter]

This is an Oracle9 bug. In Direct Oracle Access 3.4 you can work around this by supplying the table owner in the TableName property of the TOracleDirectPathLoader (e.g. SCOTT.EMP instead of EMP).

Direct Oracle Access 4.0 works around this issue.

 

[Alvaro]

Thank you but the Oracle bug you mentioned is present only with
Oracle 9 Clients, with Oracle 8 Clients it's another bug that happens all the time.
Mounted an oracle 9 instance here, tested software with Oracle8 Client and Oracle9 Client.
With Oracle8 client + your workaround same bug.
With Oracle9 client + your workaround it works Ok.
Guess the solution is changing clients and adding workaround.

Still worriend anyway..

 

[Roberto Clemente]

Hi.

I had the same problem and I fixed it the way you said (although I was adding the owner to the TableName property, it didnt work until I tried it with Oracle 9 client).

The point is, does DOA new version allow Direct Path Loading from Oracle 8 client to Oracle 9 server? Which level of compatibility between Oracle versions does it provide?

Thanks.

 

[Marco Kalter]

I think it should be compatible across all 8i and later versions.