Forum Stats

  • 3,759,024 Users
  • 2,251,493 Discussions
  • 7,870,471 Comments

Discussions

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

et4891
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 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

Not 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

Answers