Hello Srini,
I use Oracle execute snap when we have complex queries to execute. Any reason why you are not using Oracle Select query where you have an option in the Settings tab. Oracle Execute also has the same setting
From Documentation
Ignore empty result If selected, no document will be written to the output view when a SELECT operation does not produce any result. If this property is not selected and the Pass through the property is selected, the input document will be passed through to the output view.
Default value: Not selected
