On 21/09/2009, rpaliath <[email protected]> wrote: > > I am new to jmeter and I have a stored procedure which I am trying to call > using JMETER. This stored procedure returns data inside an application > defined cursor. How do I declare that?
How would you declare it in Java? > I tried using the standard definition, but I am getting a what standard definition? > "Invalid data type: <schemaname>.<packagename>.bank_holiday_cur_type" > message. I tried declaring the Parameter Type as -10, in which case it gives > me an "SQLException: Invalid column type" error. > > Here is what is set up on the JDBC Request: > > Query Type - Callable Statement > CALL <Schema Name>.<PACKAGE NAME>.GET_BANK_HOLIDAYS(P_BANK_HOLIDAYS_O) > Parameter Values: NULL > Parameter Type: -10 (I also tried P_BANK_HOLIDAYS_O <Schema Name>.<PACKAGE > NAME>.bank_holiday_cur_type; > Variable Names - P_BANK_HOLIDAYS_O > > Please let me know what is wrong here. Which version of JMeter are you using? Which JDBC are you using? Do other JDBC queries work? > Rajiv > > -- > View this message in context: > http://www.nabble.com/Return-type-is-a-Cursor-tp25530372p25530372.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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
