Skip to Main Content
Forums

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!

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

Which particular client did you install and how did you install it? Did you install the SDK?

cj
1 - 1

Post Details

Added on May 31 2021
#11g, #12c, #business-intelligence-applications, #control, #data-integrator, #system-management-and-integration, #workflow
1 comment
772 views