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
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
END LOOP;
-->
END LOOP;
COMMIT;
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;
END LOOP;
END;
--这几个字段都是什么类型如果是字符串要用 || 做连接
CREATE OR REPLACE PROCEDURE docmapfile_temp_tempid
AS
CURSOR c1
IS
SELECT docid, fileid
FROM docmapfile_temp;
BEGIN
OPEN c1 For UPDATE;
FETCH ....INTO
LOOP
EXIT WHEN C1%NOTFOUND;
UPDATE docmapfile_temp
SET tempid = c1rec.docid + c1rec.fileid
WHERE CURRENT OF c1;
END LOOP;
COMMIT;
END;