Skip to Main Content

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!

how to convert PostgreSQL text field to oracle Varchar/Clob field in ODI

Hi,
I am trying to load data from PostgreSQL table with text field to oracle Clob field but it is giving me below error when trying run the mapping
Error:-
Severity :- Fatal
Issue :- Template parser failed when parsing target expression for task: Create staging (C$) table,
Physical Design: Copy of Map09.Load_opm_events.Physical, mapping: Copy of Map09.Load_opm_events, KM: LKM SQL to Oracle (Built-In).
Error: Error when calling templated method oracle.odi.domain.mapping.generator.GeneratorContext.getAPNodeCreateTableColumnList
caused by: MapPhysicalException: Cannot generate DDL datatype for physical column event.OUTPUT1.outgoing_payload.
Caused by: Cannot generate DDL datatype for physical column event.OUTPUT1.outgoing_payload. at oracle.odi.domain.mapping.MappingUtils.getDdlDataType(MappingUtils.java:1464)
Please can someone share their thoughts.
Thank you

Comments
Post Details