Re: Bulk Collect Problem

I forgot: Oracle 8i EE, both on NT 4.0 SP 5 and Solaris 2.7.

Martin

Martin Haltmayer wrote:
>
> I found a serious problem with bulk collects. Executed once they work
> fine. A second execution, however, hangs the process. The instance
> cannot go shutdown immediate until you kill the server process:
>
> drop table test;
>
> create table test (n number);
>
> create or replace
> procedure testproc is
> cursor c is select n from test ;
> type t is table of number index by binary_integer;
> r t:= t ();
> begin
> r.delete;
> open c;
> fetch c bulk collect into r;
> close c;
> end testproc;
> /
>
> execute testproc
>
> execute testproc
>
> The second execute hangs. This problem does not occur when I do a
> disconnect and connect between the executes. It also does not occur when
> I execute the code in an anonymous PL/SQL block.
>
> Does anybody have any clue, hint or workaround for this? I appreciate
> any help. Please reply also to my e-mail.
>
> Martin
Received on Fri Jan 14 2000 - 15:57:28 CST