https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
Priority: P2
Bug ID: 54048
Assignee: [email protected]
Summary: less type choices in JDBC request
output(callablestatement)
Severity: normal
Classification: Unclassified
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: unspecified
Component: Main
Product: JMeter
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?
--
You are receiving this mail because:
You are the assignee for the bug.
