ORA-24795 when umlauts are used in unicode connection

[855D]

Hi

We recently upgraded from "8.5.563.0" to "dotConnect for Oracle 9.6.584".
Since than, we are facing problems which can be reproduced using the "dotConnect for Oracle Samples" of vers. 9.6.584".

To reproduce the unexpected behaviour:
A) Add

Code: Select all

"connection.Unicode = true;" 

in ..\Devart\dotConnect\Oracle\Samples\General\CS\ConnectForm.cs the following line in he "btConnect_Click" handler, before opening the connection.

B) Then modify in ..\Devart\dotConnect\Oracle\Samples\General\CS\Loader\LoaderDemoControl.cs

Code: Select all

loader.SetValue(1, "test string");

to

Code: Select all

loader.SetValue(1, "öäöäöäöäöäöä");

C) Connect to the database without checking "direct" option. Use the TNS File entry. Otherwise you won't be able to reproduce the behaviour.

D) Load and Fill..

End you will get Error: ORA-24795

What is the reason for that?

Thanks and regards



nls_database_parameters
NLS_RDBMS_VERSION 12.2.0.1.0
NLS_NCHAR_CONV_EXCP FALSE
NLS_LENGTH_SEMANTICS BYTE
NLS_COMP BINARY
NLS_DUAL_CURRENCY $
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_SORT BINARY
NLS_DATE_LANGUAGE AMERICAN
NLS_DATE_FORMAT DD-MON-RR
NLS_CALENDAR GREGORIAN
NLS_NUMERIC_CHARACTERS .,
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8ISO8859P1
NLS_ISO_CURRENCY AMERICA
NLS_CURRENCY $
NLS_TERRITORY AMERICA
NLS_LANGUAGE AMERICAN

[Pinturiccio]

Please create and send us a complete small test project with the corresponding DDL script for reproducing the issue.