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 getting returned to the regular output with each column in the data as it’s own array. I haven’t been able to locate any documentation how to use the result set output. Has anyone used the result set output successfully?