Re: 10g Rel 2 Problems, Possible DOS threat????

From: Bob Jones <email_at_me.not>
Date: Thu, 28 Sep 2006 02:53:57 GMT
Message-ID: <9PGSg.17802$Ij.6838@newssvr14.news.prodigy.com>

<Geek.Empire_at_gmail.com> wrote in message news:1159379127.264537.44730_at_i3g2000cwc.googlegroups.com...
> 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.
>

This code is not only bad but pointless. Why is there BULK COLLECT in the DECLARE section? Received on Wed Sep 27 2006 - 21:53:57 CDT