Here is an example pipeline that performs the step that I had described, but I hadn’t tested it until now to see that there are two Mappers that need to be introduced to get the behavior I described.
Basically, the “Map dummy value” snap just creates an input document for the Oracle - Execute snap to enable the Passthrough so it will generate something on the output even if no records are present from the query. The “Remove $original” strips that dummy element off the output records - finally, the “Has data?” Router snap can check to see if the input document is empty using the syntax I had provided earlier.
Pipeline attached: Community 13057 - Oracle Execute with no data_2022_08_04.slp (6.8 KB)
