Re: Bulk Collect Problem

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sun, 16 Jan 2000 21:07:13 +0200
Message-ID: <388216E1.920F5015@0800-einwahl.de>

Oops, sorry, wrong example:

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;
begin
        r.delete;
        open c;
        fetch c bulk collect into r;
        close c;

end testproc;
/

execute testproc

execute testproc

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 Sun Jan 16 2000 - 13:07:13 CST