PLS-00302: 必须说明 'DOCMAPFILE_TEMP_TEMPID ' 组件
点击右边红色标题查看本文完整版：PLS-00302: 必须说明 'DOCMAPFILE_TEMP_TEMPID ' 组件
CREATE OR REPLACE PROCEDURE docmapfile_temp_tempid
AS
? CURSOR c1
? IS
? SELECT docid, fileid
? FROM docmapfile_temp;
BEGIN
? FOR c1rec IN c1
? LOOP
? UPDATE docmapfile_temp
? SET tempid = c1rec.docid + c1rec.fileid
? WHERE docid = c1rec.docid AND fileid = c1rec.fileid;
? COMMIT;
? END LOOP;
END;
/
ORA-06550: 第 2 行, 第 12 列:
PLS-00302: 必须说明 'DOCMAPFILE_TEMP_TEMPID ' 组件
ORA-06550: 第 2 行, 第 3 列:
PL/SQL: Statement ignored
------解决方法--------------------
漏了个is？
------解决方法--------------------
COMMIT;
END LOOP;
-->
END LOOP;
COMMIT;
------解决方法--------------------
END LOOP;
END;
-->
? END LOOP;
END docmapfile_temp_tempid;
------解决方法--------------------
--编译没有错误啊
CREATE OR REPLACE PROCEDURE docmapfile_temp_tempid
AS
? CURSOR c1
? IS
? --SELECT docid, fileid
? -- FROM docmapfile_temp;
? select * from b_areas;
BEGIN
? FOR c1rec IN c1
? LOOP
? --UPDATE docmapfile_temp
? -- SET tempid = c1rec.docid + c1rec.fileid
? --WHERE docid = c1rec.docid AND fileid = c1rec.fileid;
? dbms_output.put_line (c1rec.area_id);
? COMMIT;
