create or replace procedure stuprocess
as
begin
dbms_output.put_line('can not open the table');
end;
as
begin
dbms_output.put_line('can not open the table');
end;
解决方案 »
- 性能问题:SQL优化,索引已经利用上,最终返回也不多,为什么还是很慢
- 在lomboz eclipse中连接 oracle 11G?
- oracle的日期最终能以整数形式显示吗
- 如何让sqlplus显示成英文
- 想要安装oracle数据库(高手进)
- 为何不能以SYSDBA的权限进入SQL*PLUS?
- 该用那个数据类型?好为难!
- 关于oracle 11i 的安装问题
- 在imp一个ORACLE数据库,怎么样让系统自动创建用户?
- select * from table1 where columan1 like '&abc'
- 关于oralce9i下的pro*cobol编程(大侠帮忙!)
- 一个游标的问题,请教高手
as
begin
dbms_output.put_line('can not open the table');
end stuprocess;
帮忙在看看以下的create or replace procedure stuprocess(
tempp in stu.p%type,
tempe in stu.e%type,
tempm1 in stu.m1%type,
tempm2 in stu.m2%type,
tempm3 in stu.m3%type,
tempsum in result.resultsum%type) assturecord stu%rowtype;
stusum result.resultsum%type;
stuflag varchar2(4);
cursor stucursor is select * from stu;errmessage exception;begin
open stucursor;
if stucursor%notfound then
raise errmessage;
end if;loop
fetch stucursor into sturecord;
stusum:=sturecord.e+sturecord.p+sturecord.m1+sturecord.m2+sturecord.m3;
if ((sturecord.e>=tempe) and
(sturecord.p>=tempp) and
(sturecord.m1>=tempm1) and
(sturecord.m2>=tempm2) and
(sturecord.m3>=tempm3) and
(stusum>=tempsum)) then
stuflag:='录取';
else
stuflag:='落选';
end if;
exit when stucursor%notfound;
insert into result values(sturecord.bh,sturecord.xm,sturecord.lb,sturecord.e,sturecord.p,sturecord.m1,sturecord.m2,sturecord.m3,stusum,stuflag);
end loop;
close stucursor;
commit;
exception
when errmessage then
dbms_output.put_line('can not open the table');
end; 也说"编译错误"
stu和result是两个表万分感谢!!!
create or replace procedure stuprocess
is
...