jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: Return type is a Cursor
Date Mon, 21 Sep 2009 15:37:04 GMT
On 21/09/2009, rpaliath <rajivpaliath@hotmail.com> 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: jmeter-user-unsubscribe@jakarta.apache.org
>  For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message