looking at your screen , I dont think what you are doing is correct. The parameter types/values are for the ? binding parameters, you have specified everything explicitly . I also dont think you can return the RefCursor as the variable name , I believe this is only possible if the statement returns a ResultSet (in your case this is an OUT parameter)
On Fri, Sep 25, 2009 at 11:05 AM, rpaliath <[email protected]> wrote: > > Deepak, I have a ref cursor being returned. How do I declare that? I have a > CSV file which is taking care of the 3 input variable neede > http://www.nabble.com/file/p25616563/jmeter.bmp jmeter.bmp d, but I am > confused about the ref cursor. The JDBC request is going out fine. Here is > what I see on the "Request" tab of the Results tree > > call <schema>.<package>.GET_TRANSFER_BY_ID (52626820,0,0,P_TRANSFER_O) > But, it is returning a "Invalid Column Type" message. > > Rajiv > > > Deepak Shetty wrote: > > > > > 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] > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/Return-values-on-Stored-Procedure-tp6429881p25616563.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] > >
