Forum Stats

  • 3,851,525 Users
  • 2,263,993 Discussions


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

et4891 Member Posts: 17 Green Ribbon

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

Not 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