站内搜索: 请输入搜索关键词

当前页面: 开发资料首页JSP 专题急急!高分求助调用存储过程的程序,看什么错误!

急急!高分求助调用存储过程的程序,看什么错误!

摘要: 急急!高分求助调用存储过程的程序,看什么错误!


存储过程:
CREATE OR REPLACE PROCEDURE PRO_FGD ( i_tjny in varchar2,--统计年月
o_hjsb out number,--合计上报
o_beijingsboutnumber,--北京上报
o_tianjinsboutnumber,--天津上报
o_hebeisboutnumber,--河北上报
o_hjqf out number,--合计上报
o_beijingqfoutnumber,--北京上报
o_tianjinqfoutnumber,--天津上报
o_hebeiqfoutnumber,--河北上报
) IS
TS NUMBER(15);-- 条数
DM VARCHAR2(4);-- 区域代码
-- 上报
CURSOR C1 IS
SELECT NVL(COUNT(1),0),C.CITY_PORT FROM TS_ZYSP_FGD_XF A,TS_SJBXX B,XJ_CITY C
WHERE TO_CHAR(B.BDJSSJ,'YYYYMM') = i_tjny AND A.JSSJBH = B.SJBH
AND B.YFD = C.CITY_GIEP AND C.CITY_FLAG IN ('1','2')
GROUP BY C.CITY_PORT
ORDER BY C.CITY_PORT;
-- 清分
CURSOR C2 IS
SELECT NVL(COUNT(1),0),C.CITY_PORT FROM TS_ZYSP_FGD_XF A,TS_SJBXX B,XJ_CITY C
WHERE TO_CHAR(B.BDFSSJ,'YYYYMM') = i_tjny AND A.FSSJBH = B.SJBH
AND B.MDD = C.CITY_GIEP AND C.CITY_FLAG IN ('1','2')
GROUP BY C.CITY_PORT
ORDER BY C.CITY_PORT;
begin
o_hjsb := 0;
o_beijingsb:= 0;
o_tianjinsb:= 0;
o_hebeisb:= 0;
o_hjqf := 0;
o_beijingqf:= 0;
o_tianjinqf:= 0;
o_hebeiqf:= 0;
-- 上报
OPEN C1;
LOOP
FETCH C1 INTO TS, DM;
EXIT WHEN C1%NOTFOUND;
BEGIN
CASE DM
WHEN '11' THENo_beijingsb := TS;--北京上报
WHEN '12' THENo_tianjinsb := TS; --天津上报
WHEN '13' THEN o_hebeisb := TS; --河北上报

ELSE NULL;
END CASE; END;
END LOOP;
CLOSE C1;
-- 上报合计
o_hjsb := o_beijingsb + o_tianjinsb + o_hebeisb;

-- 清分
OPEN C2;
LOOP
FETCH C2 INTO TS, DM;
EXIT WHEN C2%NOTFOUND;
BEGIN
CASE DM
WHEN '11' THENo_beijingqf := TS;--北京清分
WHEN '12' THENo_tianjinqf := TS; --天津清分
WHEN '13' THEN o_hebeiqf := TS; --河北清分
ELSE NULL;
END CASE;
END;
END LOOP;
CLOSE C2;
-- 清分合计
o_hjqf := o_beijingqf + o_tianjinqf + o_hebeiqf;
end;/

下面是我的程序:
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.util.*,java.text.*,java.sql.*" %>

<%

String I_TJNY = "";
int O_HJSB = 0;
int O_BEIJINGSB = 0;
int O_TIANJINSB = 0;
int O_HEBEISB = 0;
int O_HJQF = 0;
int O_BEIJINGQF = 0;
int O_TIANJINQF = 0;
int O_HEBEIQF = 0;
String strSQL = "";
java.sql.ResultSet sqlRst; //结果集对象
//准备SQL语句
strSQL = "{call PRO_FGD('200601', O_HJSB, O_BEIJINGSB, O_TIANJINSB,O_HEBEISB,O_HJQF,
O_BEIJINGQF, O_TIANJINQF, O_HEBEIQF)}";
%>

<head>


JSP数据库操作例程 - 存储过程