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]
