Hi,
This code is far too slow. Can some show me some code to speed it up.
Many thanks.
- PL SQL CODE
OPEN val_cur;
- about 100,000 records
LOOP
FETCH val_cur
INTO c1rec;
EXIT WHEN val_cur%NOTFOUND ;
parent_parent_zuidbook := getparent (p_uid =>
c1rec.uidvalue); -- function call gets an ID number.
IF parent_zuidchh IS NOT NULL
THEN
UPDATE zbook a
SET a.zuidparent = c1rec.zuidbook
WHERE a.zuidbook = parent_zuidbook;
UPDATE zbook a
SET a.ztype = 'U'
WHERE a.zuidbook = c1rec.zuidbook;
ELSE
UPDATE zbook a
SET a.ztype = 'I'
WHERE a.zuidbook = c1rec.zuidbook;
END IF;
END LOOP;
CLOSE val_cur;
--------------------------------------------------------------------------------
Received on Tue Feb 28 2006 - 23:34:14 CST
