Forum Discussion

vincenr's avatar
vincenr
New Contributor III
4 years ago

How can I test for no rows back from Oracle query

I am trying to figure out how to route to a ‘no data’ path when nothing is returned from my select query. Can someone help me out? What I’ve tried is (in ‘Is there data?’ snap): $retval != n...
vincenr's avatar
vincenr
New Contributor III
3 years ago

I am revisiting this issue because I still can’t get your $={} comparison to work when there is data vs. when there isn’t? Can you assist with this?

smudassir's avatar
smudassir
Employee
3 years ago

After your Oracle snap, put an Exit snap with threshold set to zero.
And run the above pipline as a child via PipeExec with error view. If pipeexec’s error view gets populated then there is output of query. If only output view of the pipeexec gets populated then there is no output from the query. HTH