The current parameter types in jdbc request only rely only on java.sql.Types. I suggest as as enhancement to increase the types. The improvement is necessary because sometimes,the output parameter is not the types in java.sql.Types.Maybe a cursor or others. Here is an example: Stored Procedure : create or replace procedure RK_JSCX ( OUTTABLE out sys_refcursor, OUTINFO out varchar2 ) as begin open OUTTABLE for select PONUM,ITEMNUM,DESCRIPTION,CSTM_MOD,ORDERQTY,REQUESTEDBY from RECMAT; OUTINFO:=1; exception when no_data_found then OUTINFO :=2; rollback; end RK_JSCX; my sql query in jmeter : declare outinfo varchar2(20); outtable sys_refcursor; begin {call RK_JSCX(?,?)}; end; and what's type for my first output parameter?
This is how to do it: SQL Query : call RK_JSCX(?,?) Parameter values : OUT, OUT Parameter types : OUT -10,OUT VARCHAR -10 being the int value of OracleTypes.CURSOR Variable names: cursor, outInfo Names are what you want JMeter allows using more types than java.sql.Types constantes, in this case instead of using Constant names, you use integer values of constants.
Date: Sat Oct 27 18:32:46 2012 New Revision: 1402838 URL: http://svn.apache.org/viewvc?rev=1402838&view=rev Log: Fixed some errors Modified: jmeter/trunk/xdocs/changes.xml
(In reply to comment #2) > Date: Sat Oct 27 18:32:46 2012 > New Revision: 1402838 > > URL: http://svn.apache.org/viewvc?rev=1402838&view=rev > Log: > Fixed some errors > > Modified: > jmeter/trunk/xdocs/changes.xml WRONG COMMENT
Date: Sat Oct 27 18:34:59 2012 New Revision: 1402840 URL: http://svn.apache.org/viewvc?rev=1402840&view=rev Log: Bug 54048 - less type choices in JDBC request output(callablestatement) Bugzilla Id: 54048 Modified: jmeter/trunk/xdocs/usermanual/component_reference.xml
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/2959