JDBC代码
statement.setString(1, enddate);
statement.setString(2, unit);
statement.setInt(3, thisyear);
statement.setString(4, startyearmonth);
statement.setString(5, endyearmonth);
statement.registerOutParameter(6,OracleTypes.ARRAY,****);
statement.execute();
ARRAY result = statement.getARRAY(6);
String [] values =(String [])result.getArray();
arrayList.add(0,values);
statement.close();
}
存储过程的代码 部分代码
create or replace procedure diseasenumberinfo(date2 in varchar, unit in varchar , thisyear in number ,startyearmonth in varchar,endyearmonth in varchar, sumdate out STRING_ARRAY)
as
begin
sumdate :=STRING_ARRAY(null,null,null,null,null,null,null,null,null,null);
SELECT COUNT(*) into sumdate(1) FROM ( select * from i_clinicSpecial , i_employee
WHERE ics_unit = unit AND IE_SUPPLYTAG ='1'
AND IE_SUPPLYUNITBEGIN < date2
AND ( IE_SUPPLYRETIREDATE > date2 OR IE_SUPPLYRETIREDATE IS NULL )
AND ie_cardId =ics_cardId
*** 星号的地方应该写个String参数 原先的代码写的是"STRING_ARRAY" 不过系统报错说"STRING_ARRAY"不存在
想问下这个String参数应该写什么?
statement.setString(1, enddate);
statement.setString(2, unit);
statement.setInt(3, thisyear);
statement.setString(4, startyearmonth);
statement.setString(5, endyearmonth);
statement.registerOutParameter(6,OracleTypes.ARRAY,****);
statement.execute();
ARRAY result = statement.getARRAY(6);
String [] values =(String [])result.getArray();
arrayList.add(0,values);
statement.close();
}
存储过程的代码 部分代码
create or replace procedure diseasenumberinfo(date2 in varchar, unit in varchar , thisyear in number ,startyearmonth in varchar,endyearmonth in varchar, sumdate out STRING_ARRAY)
as
begin
sumdate :=STRING_ARRAY(null,null,null,null,null,null,null,null,null,null);
SELECT COUNT(*) into sumdate(1) FROM ( select * from i_clinicSpecial , i_employee
WHERE ics_unit = unit AND IE_SUPPLYTAG ='1'
AND IE_SUPPLYUNITBEGIN < date2
AND ( IE_SUPPLYRETIREDATE > date2 OR IE_SUPPLYRETIREDATE IS NULL )
AND ie_cardId =ics_cardId
*** 星号的地方应该写个String参数 原先的代码写的是"STRING_ARRAY" 不过系统报错说"STRING_ARRAY"不存在
想问下这个String参数应该写什么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货