Forum Discussion

rmartyn's avatar
rmartyn
New Contributor II
5 years ago

Using Oracle Execute to run complicated SQL Select not returning any data

I’m new to SnapLogic and was told by one of our senior SL developers that instead of using the Oracle Select snap, I could use the Oracle Execute snap to run a complex SQL select statement. When I t...
oracle
dmiller's avatar
dmiller
Former Employee
5 years ago

@rmartyn Oracle Execute is not connected to CSV Formatter. Open the Oracle Execute Snap, go to the Views tab and add an output view. Save the Snap then make sure the circle between the two Snaps is shaded in.

  • rmartyn's avatar
    rmartyn
    New Contributor II
    5 years ago

    Thank you DMiller!!! That was the piece I was missing!