通过编译,但是运行系统时候没有效果出来,一下是储存过程代码
create or replace procedure test_zc as
Z_OBJMRC R5OBJECTS.OBJ_MRC%TYPE;
Z_OBJDESC R5OBJECTS.OBJ_DESC%TYPE;
z_ordqty r5orderlines.orl_ordqty%TYPE;
z_part r5orderlines.orl_part%TYPE;
z_order r5orderlines.orl_order%TYPE;
d NUMBER := 1;
cursor cur_part
is
SELECT orl_order,orl_part,orl_ordqty FROM R5ORDERLINES where ORL_PART in(select par_code from R5PARTS where par_byasset='+');
begin
open cur_part ;
loop
fetch cur_part into z_order,z_part,z_ordqty;
while d <z_ordqty
loop
select par_desc into Z_OBJDESC from R5PARTS where par_byasset='+'and par_code =z_part;
SELECT W.USR_MRC INTO Z_OBJMRC FROM R5USERS W WHERE W.USR_CODE IN(SELECT ORD_ORIGIN FROM R5ORDERS WHERE ORD_code=z_order );
INSERT INTO R5OBJECTS ( OBJ_CODE, OBJ_DESC, OBJ_OBTYPE, OBJ_OBRTYPE, OBJ_CLASS, OBJ_DEPEND, OBJ_STATUS, OBJ_RSTATUS, OBJ_GROUP, OBJ_USER, OBJ_NOTUSED, OBJ_SAFETY, OBJ_ORG, OBJ_CLASS_ORG, OBJ_MRC) VALUES(S5AUTOOBJ.nextval,Z_OBJDESC,'A','A','','-','A','A','R5','R5','-','-','*','',Z_OBJMRC);
d:=d+1;
end loop; exit when cur_part%notfound;
DBMS_OUTPUT.put_line('结束循环');
end loop; end;Cursorselect
create or replace procedure test_zc as
Z_OBJMRC R5OBJECTS.OBJ_MRC%TYPE;
Z_OBJDESC R5OBJECTS.OBJ_DESC%TYPE;
z_ordqty r5orderlines.orl_ordqty%TYPE;
z_part r5orderlines.orl_part%TYPE;
z_order r5orderlines.orl_order%TYPE;
d NUMBER := 1;
cursor cur_part
is
SELECT orl_order,orl_part,orl_ordqty FROM R5ORDERLINES where ORL_PART in(select par_code from R5PARTS where par_byasset='+');
begin
open cur_part ;
loop
fetch cur_part into z_order,z_part,z_ordqty;
while d <z_ordqty
loop
select par_desc into Z_OBJDESC from R5PARTS where par_byasset='+'and par_code =z_part;
SELECT W.USR_MRC INTO Z_OBJMRC FROM R5USERS W WHERE W.USR_CODE IN(SELECT ORD_ORIGIN FROM R5ORDERS WHERE ORD_code=z_order );
INSERT INTO R5OBJECTS ( OBJ_CODE, OBJ_DESC, OBJ_OBTYPE, OBJ_OBRTYPE, OBJ_CLASS, OBJ_DEPEND, OBJ_STATUS, OBJ_RSTATUS, OBJ_GROUP, OBJ_USER, OBJ_NOTUSED, OBJ_SAFETY, OBJ_ORG, OBJ_CLASS_ORG, OBJ_MRC) VALUES(S5AUTOOBJ.nextval,Z_OBJDESC,'A','A','','-','A','A','R5','R5','-','-','*','',Z_OBJMRC);
d:=d+1;
end loop; exit when cur_part%notfound;
DBMS_OUTPUT.put_line('结束循环');
end loop; end;Cursorselect
解决方案 »
- group by 分组时 or 的问题,疑难杂症,坐等牛人。。
- 請教:RHEL5中oracle database 10g express安裝以及怎樣配置
- --求高人相助:一个SQL Server 2005的存储过程转换为Oracle的---
- 关于监听自动关闭的问题
- 面试题,请高手们看看
- 动态sql的commit问题
- 游标的使用问题
- 我做了一个视图,只关联两个表,用管理工具打开浏览时需要十几分钟的时间,这是为什么?(两个表分别有11万条数据)
- oracle 随机函数出错?
- 为什么没有显示结果?求助。
- Oracle SQL Developer的SQL工作表不能正常编辑
- 急急急,linux,sqlplus 命名出错 ORA-12547: TNS:lost contact
前少了初始化d:=1;