存储过程方法,create or replace procedure calcDepVulnValue(pi_nDepartmentID in Number, po_nValue out Number)
一个是入参,一个是出参。
我在程序里:public String calOneLevelVulnValue(long nodeId) {
String result = "";
StringBuffer sbSQL = new StringBuffer();
sbSQL.append(" call calcDepVulnValue(@pi_nDepartmentID) ");
Sql sql = Sqls.fetchString(sbSQL.toString());
sql.params().set("pi_nDepartmentID", nodeId);
this.dao.execute(sql);
result = sql.getString();
return result;
}
结果报错java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'CALCDEPVULNVALUE'
请问正确的nutz调用过程的方法是如何的?
添加回复
请先登陆