Forum Discussion

wpenfold's avatar
wpenfold
Contributor
5 years ago

How do you use the Result Set output on the Oracle Stored Procedure snap?

I have an Oracle stored function that returns a ref cursor. When I call it from an Oracle Stored Procedure snap, I’d like the data returned to the Result Set output (I think), but instead, it’s gett...
oracle
charve03's avatar
charve03
New Contributor
5 years ago
Copy LinkReport

Did you get a response to this by chance? I have a similar need with an existing stored procedure that returns a query result set (ref cursor). I just want to execute the stored procedure and output results to csv

  • wpenfold's avatar
    wpenfold
    Contributor
    5 years ago
    Copy Link

    I didn’t, but I figured out if I just return a refcursor, it will return it via the regular output as a json object, then I had to use a json splitter to split it into rows