declare
vname varchar2(200);
v_bookid integer;
v_pageid integer;
CURSOR C1 IS SELECT imgname,ocrcont from pageocr;
rec C1%ROWTYPE;
BEGIN
open C1;
LOOP
FETCH C1 INTO rec;
EXIT WHEN C1%NOTFOUND;
SELECT bookid, pageid INTO v_bookid, v_pageid FROM table(F_QUERY_PAGEID3(rec.ocrcont));
INSERT INTO TEMP(BOOKID,IMGNAME,PAGEID) VALUES(v_bookid,rec.imgname,v_pageid);
END LOOP;
CLOSE C1;
END;
vname varchar2(200);
v_bookid integer;
v_pageid integer;
CURSOR C1 IS SELECT imgname,ocrcont from pageocr;
rec C1%ROWTYPE;
BEGIN
open C1;
LOOP
FETCH C1 INTO rec;
EXIT WHEN C1%NOTFOUND;
SELECT bookid, pageid INTO v_bookid, v_pageid FROM table(F_QUERY_PAGEID3(rec.ocrcont));
INSERT INTO TEMP(BOOKID,IMGNAME,PAGEID) VALUES(v_bookid,rec.imgname,v_pageid);
END LOOP;
CLOSE C1;
END;