Re: Bulk Collect Problem

We knew what you meant. It also causes a problem with user-defined types anyway.

The process goes into a spin attempting to BIND - (this can be seen from doing
alter session set events '10046 trace name context forever, level 4';

I haven't found a reasonable workaround yet and it doesn't appear to be on the 8.1.6 bug fix list.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Martin Haltmayer wrote in message <388216E1.920F5015_at_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;
>/
>
Received on Sun Jan 16 2000 - 14:07:10 CST