Kumar - Posted September 17, 2019 Share Posted September 17, 2019 Hi, Recently we migrated to Oracle 12c from Oracle 10g. I am getting below error while executing a JDBC call. it is working fine with Oracle 10g. I tried by changing input formats as INT, NUMERICAL, STRING in JDBC query palette, but issue is not resolved. Job-18000 Error in [Processes/UserLib/FindAvailableOffers/GetTVAddonOffers_2.process/Group/Group (1)/get variant] "JDBC error reported: (SQLState = 22018) - java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-01722: invalid number " "JDBC error reported: (SQLState = 22018) - java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-01722: invalid number " BW-JDBC-100014 22018 java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-01722: invalid number Link to comment Share on other sites More sharing options...
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