Skip to Main Content

Analytics Software


For appeals, questions and feedback, please email

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 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 - 64bit Production
Oracle IDE
Version in VM is below
Oracle Database 11g Enterprise Edition Release - 64bit Production
Oracle IDE