I'm using JMeter 2.2 and have set Query Type to 'Callable Statement'. Jelmer
-----Original Message----- From: sebb [mailto:[EMAIL PROTECTED] Sent: donderdag 21 september 2006 18:55 To: JMeter Users List Subject: Re: Return values on Stored Procedure As far as I know, this should work. Which version of JMeter are you using? What did you set the "Query Type" to? S. On 21/09/06, Jelmer de Haas <[EMAIL PROTECTED]> wrote: > I have managed to call the Stored Procedure (SP) on Oracle 10 from > Jmeter. > > This SP (see below) returns three values. But in the Result Tree these > are not shown, only respons is 'Executed'. > > Is there some way to show these values and do some kind of response > assertion on them? > > > DECLARE > > returnmessage VARCHAR(256); > ipaddress VARCHAR(256); > fnumber VARCHAR(256); > brand VARCHAR(256); > returncode NUMBER; > creationdate NUMBER; > > BEGIN > > BLACKLISTIP ('[EMAIL PROTECTED]', '127.0.0.66', 'brand', > returncode,returnmessage,creationdate); > DBMS_OUTPUT.PUT_LINE(returncode); > DBMS_OUTPUT.PUT_LINE(returnmessage); > DBMS_OUTPUT.PUT_LINE(creationdate); > > END; > > > Regards, > Jelmer > > > --------------------------------------------------------------------- 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]
