Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-00936: missing expression while insert data into flow table

et4891May 31 2021

I am trying to create flow control to be included for IKM so I can get the flow control to work in mapping for having E$ table to catch any exceptions, but there isn't any template on the code of the flow table. None of the IKM included flow control. Then I figured, using the Oracle VM https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html it has built in flow control in IKM so I copied the code from there to my ODI, but I am getting ORA-00936: missing expression when running the mapping.
This is the code I copied
image.pngNot sure if these versions has to do with errors but this is the version I am using
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Oracle IDE 12.2.1.3.0
Version in VM is below
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Oracle IDE 12.2.1.3.1

Comments