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 bugzi...@apache.org wrote: > > https://issues.apache.org/bugzilla/show_bug.cgi?id=45657 > > > Sebb <s...@apache.org> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|NEW |RESOLVED > Resolution| |FIXED > > > > > --- Comment #2 from Sebb <s...@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-unsubscr...@jakarta.apache.org > For additional commands, e-mail: jmeter-dev-h...@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-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-dev-h...@jakarta.apache.org
