http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request
see Parameter Types (you'd say something like OUT INTEGER) If the callable statement has INOUT or OUT parameters, then these must be indicated by prefixing the appropriate parameter types, e.g. instead of "INTEGER", use "INOUT INTEGER". If not specified, "IN" is assumed, i.e. "DATE" is the same as "IN DATE". If the type is not one of the fields found in java.sql.Types, versions of JMeter after 2.3.2 also accept the corresponding integer number, e.g. since INTEGER == 4, you can use "INOUT 4". There must be as many types as there are placeholders in the statement. regards deepak On Fri, Sep 25, 2009 at 10:30 AM, rpaliath <[email protected]> wrote: > > Jelmer > Can you tell me how you defined the out variables in the JDBC Request > screen? > Thanks. > > > > Jelmer de Haas 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 > > > > > > > > -- > View this message in context: > http://www.nabble.com/Return-values-on-Stored-Procedure-tp6429881p25615942.html > Sent from the JMeter - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
