Bulk Collect Problem

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Fri, 14 Jan 2000 23:51:27 +0200
Message-ID: <387F9A5F.D6D2EC3F@0800-einwahl.de>

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:51:27 CST