create or replace procedure SH_getXiaoGuoQingKuangShuilist(StartDate in varchar2, EndDate in varchar2, JingHao in varchar2) is begin select a.JH into v_jh, a.RQ into v_rq, a.ZSYL into v_zsyl, a.RZSL into v_rzsl, a.BZ into v_bz FROM BB_SJXG a where a.rq >= to_date(StartDate, 'yyyymmdd') AND a.rq <= to_date(EndDate, 'yyyymmdd') and a.jh = JingHao; end SH_getXiaoGuoQingKuangShuilist;改了后说未找到预期关键字from pl/sql:statement ignored
create or replace procedure SH_getXiaoGuoQingKuangShuilist(StartDate in varchar2, EndDate in varchar2, JingHao in varchar2) is begin select a.JH, a.RQ, a.ZSYL, a.RZSL, a.BZ INTO v_jh, v_rq, v_zsyl, v_rzsl, v_bz FROM BB_SJXG a where a.rq >= to_date(StartDate, 'yyyymmdd') AND a.rq <= to_date(EndDate, 'yyyymmdd') and a.jh = JingHao; end SH_getXiaoGuoQingKuangShuilist;
EndDate in varchar2,
JingHao in varchar2) is
begin
select a.JH into v_jh,
a.RQ into v_rq,
a.ZSYL into v_zsyl,
a.RZSL into v_rzsl,
a.BZ into v_bz
FROM BB_SJXG a
where a.rq >= to_date(StartDate, 'yyyymmdd') AND
a.rq <= to_date(EndDate, 'yyyymmdd') and a.jh = JingHao;
end SH_getXiaoGuoQingKuangShuilist;改了后说未找到预期关键字from
pl/sql:statement ignored
EndDate in varchar2,
JingHao in varchar2) is
begin
select a.JH,
a.RQ,
a.ZSYL,
a.RZSL,
a.BZ
INTO
v_jh,
v_rq,
v_zsyl,
v_rzsl,
v_bz
FROM BB_SJXG a
where a.rq >= to_date(StartDate, 'yyyymmdd') AND
a.rq <= to_date(EndDate, 'yyyymmdd') and a.jh = JingHao;
end SH_getXiaoGuoQingKuangShuilist;