khushboo golani Posted May 29, 2019 Posted May 29, 2019 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now