ODI-1228: Task PRD-Create-Populate-Table (Procedure) fails on the target ORACLE connection ORACLE_DEMO_SRC.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
Ensure the sql statements are embedded in begin..end
Oracle Data Integrator (ODI) – Trying to move an interface by dragging and dropping into another folder throws an error ODI-20057: You cannot move an interface into a folder belonging to another project
Export the interface to file system and import into the target folder.