PLS-00306: wrong number or types of arguments in call to 'PRC_UNITE_PRODUCT'
ORA-06550: line 1, column 7:请帮忙解决一下啊!
存储过程是:
create or replace procedure prc_ABC_product( areaId in varchar, beginTime out varchar ,endTime out varchar)
is
BEGIN
beginTime := 'BBBBBaaaa';
execute immediate 'DELETE FROM TEM_20080425_TB_BAKE';
execute immediate 'INSERT INTO TEM_20080425_TB_BAKE SELECT * FROM TEM_20080425_TB';
commit;
END ;
调用代码是
public ExceteStoredProcedure(DataSource dataSource,String prc_name) {
super(dataSource,prc_name);
declareParameter(new SqlParameter(IN_AREA_ID,Types.VARCHAR));
declareParameter(new SqlOutParameter(IN_BEGIN_TIME,Types.VARCHAR));
declareParameter(new SqlOutParameter(INT_END_TIME,Types.VARCHAR));
super.compile();
}
public void doCountTable(CalledNumberPo calledNumberPo)
{
String areaId = calledNumberPo.getCityCode();
String beginTime = calledNumberPo.getBeginTime();
String endTime = calledNumberPo.getEndTime();
Map paraMap = new HashMap();
paraMap.put(IN_AREA_ID, areaId);
paraMap.put(IN_BEGIN_TIME, beginTime);
paraMap.put(INT_END_TIME, endTime);
Map resultMap = super.execute(paraMap);
}
ORA-06550: line 1, column 7:请帮忙解决一下啊!
存储过程是:
create or replace procedure prc_ABC_product( areaId in varchar, beginTime out varchar ,endTime out varchar)
is
BEGIN
beginTime := 'BBBBBaaaa';
execute immediate 'DELETE FROM TEM_20080425_TB_BAKE';
execute immediate 'INSERT INTO TEM_20080425_TB_BAKE SELECT * FROM TEM_20080425_TB';
commit;
END ;
调用代码是
public ExceteStoredProcedure(DataSource dataSource,String prc_name) {
super(dataSource,prc_name);
declareParameter(new SqlParameter(IN_AREA_ID,Types.VARCHAR));
declareParameter(new SqlOutParameter(IN_BEGIN_TIME,Types.VARCHAR));
declareParameter(new SqlOutParameter(INT_END_TIME,Types.VARCHAR));
super.compile();
}
public void doCountTable(CalledNumberPo calledNumberPo)
{
String areaId = calledNumberPo.getCityCode();
String beginTime = calledNumberPo.getBeginTime();
String endTime = calledNumberPo.getEndTime();
Map paraMap = new HashMap();
paraMap.put(IN_AREA_ID, areaId);
paraMap.put(IN_BEGIN_TIME, beginTime);
paraMap.put(INT_END_TIME, endTime);
Map resultMap = super.execute(paraMap);
}
解决方案 »
- PB调用ORACLE问题.
- 如何写一个不依赖于Oracle Client的C#程序
- 求sql语句,急!!!在线等待
- 请问我的这个写法哪里错了?
- *******小女子有事需要大家帮忙?(从VFP库中取数据至Oracle(每天23:00执行)(邹健及各位高手请不吝赐教)*****
- oracle9i 中表空间大小只能设置为最大到1G,再大的话就会出错!
- 安装9i问题
- 我如何在Oracle系统表中取得我自己的某一表所有的非空字段?还有PK字段呢,请教
- 触发器,调用带参数的存储过程...老报错误!
- oracle12 打不开管理控制台
- ORACLE 10G em当中有关违反策略的情况?
- 100分向高手请教一个存储解决方案,我是学生啊...
(
areaId in varchar2,
beginTime out varchar2,
endTime out varchar2
)
is
begin
savepoint proc; --事务保存点
beginTime := 'BBBBBaaaa';
endTime := '';
execute immediate 'DELETE FROM TEM_20080425_TB_BAKE';
execute immediate 'INSERT INTO TEM_20080425_TB_BAKE SELECT * FROM TEM_20080425_TB';
exception
when others then
rollback to savepoint proc;
return;
end prc_ABC_product;