rmartyn
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Using Oracle Execute to run complicated SQL Select not returning any data
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.3.8KViews0likes1CommentUsing 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 try to do that though, I get no data and I can’t figure out how to get a “snap”, such as a csv formatter, to “connect” to it. The pieces are next to each other in the pipeline, but there is nothing in the spot in between them showing they have fitted together. the only way I have been able to get it to work is by creating a database view representing the complex sql statement, then using an Oracle Select snap to pull the data from the db view.6.6KViews0likes7Comments