ora-17155 - with database adapter
Hi,
We have some esb services that use the database adapter to interact to the database. Unfortunately this database has a character set of WE8ISO8859P15. This results in a ORA-17155 - Cannot map Unicode to Oracle character exception, when the data contains special characters that are not in that character set like the ½.
As strange as it may sound, but we would happy enough to have these characters as garbage in our database, e.g. as a ¿, which is indeed be case if we just insert the data using SQL+ or SQLDeveloper. However, it seems that the database adadpter is already doing something with character sets and is not just doing a plain insert.
Is there a way to have the database adapter insert the data (with garbage characters) instead of throwing the exception?
We're using the Oracle esb 10.1.3.4 and database 10gR2.
Ciao
Aino