You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jmeter-dev@jakarta.apache.org by rpaliath <ra...@hotmail.com> on 2009/09/18 22:30:51 UTC
Re: DO NOT REPLY [Bug 45657] Callable Statement does not support
Oracle Cursor parameter type?
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? I tried using the standard definition, but I am getting a
"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.
I am using JMETER version 2.3.4.
Thanks.
Bugzilla from bugzilla@apache.org wrote:
>
> https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
>
>
> Sebb <se...@apache.org> changed:
>
> What |Removed |Added
> ----------------------------------------------------------------------------
> Status|NEW |RESOLVED
> Resolution| |FIXED
>
>
>
>
> --- Comment #2 from Sebb <se...@apache.org> 2008-11-04 08:07:29 PST ---
> By the way, it's [oracle.jdbc.]OracleTypes, not OracleType.
>
> I've added code to treat the type as an integer if it is not recognised as
> a
> standard field name:
>
> URL: http://svn.apache.org/viewvc?rev=711279&view=rev
> Log:
> JDBC Request now handles arbitray variable types
>
> This will be in nightly builds after r711279 (
> https://svn.apache.org/viewcvs.cgi?view=rev&rev=711279 ).
>
> OracleTypes.CURSOR = -10 if you want to try it out.
>
>
> --
> Configure bugmail:
> https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the assignee for the bug.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/DO-NOT-REPLY--Bug-45657--New%3A-Callable-Statement-does-not-support-Oracle-Cursor-parameter-type--tp19065028p25515046.html
Sent from the JMeter - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
Re: DO NOT REPLY [Bug 45657] Callable Statement does not support
Oracle Cursor parameter type?
Posted by sebb <se...@gmail.com>.
This is a question for the JMeter users list.
Please repost there.
Make sure you include more details as to what you tried, and the
*exact* error messages you received.
Please don't reply to Buzilla messages; if you want to refer to a
Bugzilla issue, just quote the URL.
On 18/09/2009, rpaliath <ra...@hotmail.com> wrote:
>
> 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? I tried using the standard definition, but I am getting a
> "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.
> I am using JMETER version 2.3.4.
>
> Thanks.
>
>
> Bugzilla from bugzilla@apache.org wrote:
> >
> > https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
> >
> >
> > Sebb <se...@apache.org> changed:
> >
> > What |Removed |Added
> > ----------------------------------------------------------------------------
> > Status|NEW |RESOLVED
> > Resolution| |FIXED
> >
> >
> >
> >
> > --- Comment #2 from Sebb <se...@apache.org> 2008-11-04 08:07:29 PST ---
> > By the way, it's [oracle.jdbc.]OracleTypes, not OracleType.
> >
> > I've added code to treat the type as an integer if it is not recognised as
> > a
> > standard field name:
> >
> > URL: http://svn.apache.org/viewvc?rev=711279&view=rev
> > Log:
> > JDBC Request now handles arbitray variable types
> >
> > This will be in nightly builds after r711279 (
> > https://svn.apache.org/viewcvs.cgi?view=rev&rev=711279 ).
> >
> > OracleTypes.CURSOR = -10 if you want to try it out.
> >
> >
> > --
> > Configure bugmail:
> > https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> > ------- You are receiving this mail because: -------
> > You are the assignee for the bug.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
> >
> >
> >
>
>
> --
> View this message in context: http://www.nabble.com/DO-NOT-REPLY--Bug-45657--New%3A-Callable-Statement-does-not-support-Oracle-Cursor-parameter-type--tp19065028p25515046.html
> Sent from the JMeter - Dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org