While upgrading a 9i database to 10g Rel 2 we came across some bad
code. When executed this code would cause that sql session to fully
consume one whole CPU and never return even if the user canceled the
session. I'm sure you can see where this would lead. We have been
able to recreate this with the following code:
DECLARE
TYPE DOSTestTab IS TABLE OF dual.dummy%TYPE;
vDTab DOSTestTab;
CURSOR c_DOScursor IS
SELECT dummy BULK COLLECT INTO vDTab FROM dual;
BEGIN
OPEN c_DOScursor ;
FETCH c_DOScursor BULK COLLECT INTO vDTab;
CLOSE c_DOScursor ;
END;
This, although very bad looking code, did work in 9.2.0.x.
Received on Wed Sep 27 2006 - 12:45:27 CDT
