SQL>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; if v_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;
/
SQL> exec addstuscore;
BEGIN addstuscore;END;
*
第一行出现错误:
0RA-06550:第1行,第7列:
PLS-00306:调用‘ADDSTUSCORE’时参数个数或类型错误
0RA-06550:第1行,第7行:
PL/SQL:Statement ignored
刚学oracle,不知道问题出在哪?
(
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; if v_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;
/
SQL> exec addstuscore;
BEGIN addstuscore;END;
*
第一行出现错误:
0RA-06550:第1行,第7列:
PLS-00306:调用‘ADDSTUSCORE’时参数个数或类型错误
0RA-06550:第1行,第7行:
PL/SQL:Statement ignored
刚学oracle,不知道问题出在哪?
解决方案 »
- oracle数据表导出异常
- oracle连不上
- 在pl/sql developer里12位长度以上数字显示问题
- 数据库问题,高手请进,在线等!
- 新手安装穿问题求助啊 第二步就出现问题
- 这个Oracle分页显示有错,怎么改,哪位大虾指点小弟,谢谢
- 急:9i安装时报"找不到OCS4J.Properties文件"错误,请大侠指正,有影响吗?
- sqlplus连oracle怎么这么慢啊???
- 怎样才能用LIKE查找字段本身就包含‘%’的结果?
- !急急急急急急急!!!!!求救ORACLE工程师,无法起动数据库,ORA-00600错误!!!!!
- 请问,需要那些技术
- oracle 11g client 有用过的人进来!
我试了,说是未找到数据???
带入参数到这个SQL语句里看看能不能查到数据!
insert into xs_kc values (p_xh,v_kch,p_cj,p_xf);
改为
insert into XS_KC(A,B,C,D)VALUES(P_XH,V_KCH,P_CJ,P_XF);
把字段名带上!