Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Number error when loading data from view

User_E496RJun 25 2021

I am facing an invalid number error while loading data from an ORACLE view to an Oracle Table. But, the query generated by ODI (when simulation is run) works perfectly when executed in the target database.
I tried changing all the source and target datatypes to String and VARCHAR2 but the error persists!

Added on Jun 25 2021

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

4 comments

554 views