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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Ramakrishna BoppanaDec 1 2022

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

Added on Dec 1 2022

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

0 comments

433 views