jdbc - Readable output from Oracle procedure that returns a cursor in JMeter -

i have procedure takes in 1 varchar parameter , returns out cursor list, in case 3 rows 9 columns.

my current jdbc request:

call foo.bar.procedure('123456', ?) 

• query type: callable statement
• parameter values: out
• parameter types: out -10
• variable names: outlist
• result variable name: resultlist (this null, mean result empty?)
• handle resultset: store object

response data:

-1 updates. output variables position: [1] oracle.jdbc.driver.oracleresultsetimpl@21512d0b 

outlist oracle.jdbc.driver.oracleresultsetimpl@21512d0b

i've tried getting information outlist in beanshell sampler suggested here haven't been able except resultset object id.

i'm new calling procedures through jmeter, view result tree doesn't seem show me result data , i've been going , forth sql query , parameter values, trying fix it, have same trouble output.

i've tried similar settings:

declare     refcursor sys_refcursor;     type myrec record (        v1    varchar2(        v2    varchar2(50),        ...        v13    varchar2(10));    rec myrec;    begin     foo.bar.procedure('123456',refcursor);     loop         fetch refcursor rec;         exit when refcursor%notfound;         dbms_output.put_line(          rec.v1||','||          rec.v2||','||          ...          rec.v13);    end loop; end; 

am calling procedure correctly or missing in jdbc request settings?

1. add jsr223 postprocessor child of request

2. extract "interesting" values oracleresultsetimpl per retrieving , modifying values result sets article, like:

   import java.sql.resultset  resultset rs = (resultset)vars.getobject('outlist')  while (rs.next()) {                 vars.put('column_1_row_1_value`, rs.getstring(0))      ///... } 

see jdbc tutorial , apache groovy - why , how should use it more details.