E1: FDA: Using LIKE Operation in Table I/O Event Rule (Doc ID 638929.1)

Last updated on JUNE 14, 2021

Applies to:

Goal

I am attempting to use the LIKE operation in a Table I/O statement.  However the LIKE operator is not functioning correctly.  The SQL statement that is being generated is performing an equal rather than a "LIKE".

For example, the SQL generated is

SELECT * FROM PRODDTA.F4220 WHERE SWSRL1 = '01541097'

when I want it to be

SELECT * FROM PRODDTA.F4220 WHERE SWSRL1 LIKE '
541097%'

I am using an assignment in the event rules to set the value to a particular value, 01541097 and then use that value in table I/O.  I have set Table I/O operation to the LIKE operation.  How can I get this to function? 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.