> Hi > You would need to write some java program that prints out > java.sql.Types.OTHER. I just ran it the value would be 1111. > > So in your > Types VARCHAR,OUT 1111 > ParameterValues siioTSC09,]NULL[ > > Note that i havent run any Oracle SP with jmeter so Im guessing based on > how > I would have to implement this for calling the SP directly from Java. The > problem really is that Oracle doesnt directly allow you to return a > ResultSet from an SP (like say MS SQL server does and I dont think the > current JDBC sampler handles this idiosyncrasy in oracle too well)
Actually, if the stored procedure is a 'table' function (or 'PIPELINED' function), you can do SELECT * FROM TABLE(name_of_your_pipelined_function) and get a normal resultset. Mark -- Mark Rotteveel Pluton IT --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
