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
rmartyn's avatar
rmartyn
New Contributor II
5 years ago

Hi Vineesha,

Thank you for responding. My SQL is quite a bit more complicated than your example. It includes several “With” statements and such. I’m just wondering if SnapLogic can’t handle that? It runs fine if I put it in SQL Developer.

vineesha's avatar
vineesha
Employee
5 years ago

Hi,
For the comprehensive scripting functionality you should use stored procedure functionality in the Stored Procedure Snap.