|
楼主 |
发表于 2014-2-24 09:57:07
|
显示全部楼层
有个新问题,我还是搞不定:
我的存储过程一个输入参数,一个输出参数为输出集,
Action代码:
public static Table returntable(String v1){
java.sql.Connection conn;
try{
conn = com.justep.model.ModelUtils.getConnection("/report/reptest/data");
java.sql.CallableStatement proc = conn.prepareCall("{call test2 (?)}");
proc.setString(1, v1);
ResultSet rt = proc.executeQuery();
//proc.execute();
System.out.println(rt);
return com.justep.system.util.BizUtils.resultSet2Table( rt,"/report/reptest/data");
// System.out.println(v1);
}
catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;}}}
.w文件代码:
staticActivity1.dataModelLoad = function(event){
var options = {};
var param = new justep.Request.ActionParam();
var vchar = 'fdsa';
param.setString('v1',vchar);
options.parameters = param;
options.action = "returntable";
var result = justep.Request.sendBizRequest2(options);
justep.xbl('gridReport').refresh();}
控件台错误 :java.sql.SQLException: ORA-06550: line 1, column 7LS-00306: wrong number or types of arguments in call to 'TEST2'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
是哪里错了呢,自己确定不清楚,该 怎么样写,求指教。
|
-
定义的ACTION
|