错误类型:
ADODB.Command (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/xscj/AddStuScore.asp, 第 20 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; QQDownload 1.7)
网页:
POST 107 ??? /xscj/AddStuScore.asp
POST Data:
StuXH=061101&StuXM=061101&StuKCM=%BC%C6%CB%E3%BB%FA%BB%F9%B4%A1++++++&StuCJ=44&StuXF=55&StuUpd=%B8%FC%D0%C2
对应代码是:function OnLoad(){
我的存储过程:create or replace procedure addstuscore
(
p_xh in xs.xh%type,
p_kcm in kc.kcm%type,
p_cj in xs_kc.cj%type,
p_xf in xs_kc.xf%type
)
as
v_kch kc.kch%type;
v_count number;
begin
select kc.kch into v_kch from kc where kc.kcm=p_kcm;
select count(*) into v_count from xs_kc where xs_kc.xh=p_xh and xs_kc.kch=v_kch;
ifv_count=1 then
update xs_kc set xs_kc.cj=p_cj,xs_kc.xf=p_xf where xs_kc.xh=p_xh and xs_kc.kch=v_kch;
else
insert into xs_kc values(p_xh,v_kch,p_cj,p_xf);
end if;
end;
/
我用的是oracle啊,怎么会看不懂呢?
|