Re: Getting result set output parameter from Oracle SP using JDBCR4

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Alvaro,

I'm not sure I understand.  To me, a parameter is passed on the call to 
the stored procedure

CALL MYPROCEDURE(parameter-here)

And a result set is a list of rows/columns that are returned from the 
call (the same way as the SELECT SQL statement returns a list of 
rows/columns.)

So I'm not sure what you mean by the result set is an output parameter?  
Do you just mean you need to get an output parameter (rather than a 
result set)?   Or do you mean that you need to get a result set?  or 
multiple result sets?   Its not clear.

If you can show an example of what the data looks like, that'd be very 
helpful.

-SK


On 8/26/2020 8:48 PM, Alvaro Cancino wrote:
>     Greetings,
>
>      
>
>      
>
>     I'm trying to use JDBCR4, Scott Klemetnt's,
>
>     I have to call an Oracle SP from from RPG Program but  a  result set is
>     one of the output parameters of Store procedure
>
>      
>
>      
>
>     Is there a way to retrieve a result set output parameter?
>
>      
>
>      
>
>     Thanks
>
>      
>
>     Alvaro Cancino G.
>
>      
>
>     Sent from [1]Mail for Windows 10
>
>      
>
> References
>
>     Visible links
>     1. https://go.microsoft.com/fwlink/?LinkId=550986