Getting error - INTERNAL ERROR: Binding NAMED_TYPE but no type defined

[khushboo golani]

I am trying to store data from tibco BW to Oracle database, using a stored procedure.

I am getting below error while trying to do so from only 1 SP, from the 5 SPs that i have added in BW.

"JDBC error reported: (SQLState = 99999) - java.sql.SQLException: INTERNAL ERROR: Binding NAMED_TYPE but no type defined"

The issue is that the data that i am storing has special characters in it - e.g. - "Wauthier Frdric de Wasseige".

the table that i am storing this data to has multiple columns, and for only 1 column the above error is occurring, if i remove the special characters for this 1 column then the data is stored properly in the table. For other columns also the name "Frdric" is being used, as this is the users name. Just for 1 column the special characters are not getting inserted, while for other columns there is no issue.

I have checked the UTF encoding for the DB using below query, and i can see that column "NLS_CHARACTERSET" has value "UTF8".

select * from database_properties;

Please let me know what other check can be performed to debug why this error is occurring only for 1 column of 1 table.

I have also tried to change the column data type from VARCHAR2 to NVARCHAR2, but this did not work.