Hi Mark, Thank you. This way it works much better! SELECT * FROM TABLE(name_of_your_pipelined_function) and get a normal resultset.
BR, James -----Original Message----- From: Mark Rotteveel [mailto:[email protected]] Sent: Friday, October 23, 2009 7:25 AM To: JMeter Users List Subject: Re: JMeter - How do i run a stored procedure > 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
