Re: Bulk Collect Problem

Many thanks for your reply. It is valuable to know when considering a switch to 8.1.6 (which came out for Solaris 12/01).

Martin

Jonathan Lewis wrote:
>
> 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:49:11 CST