Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Added on May 31 2021

#11g, #12c, #business-intelligence-applications, #control, #data-integrator, #system-management-and-integration, #workflow

1 comment

737 views