Re: Refcursor bug

On 27-Apr-07, at 1:56 PM, Altaf Malik wrote:

> Yes it is useless but at least we cannot prevent the user from
> doing it. Does it mean we should throw exception and not allow user
> to get even the first resultset? Because exception comes internally
> when processing the resultset.

There's many things the user can do that don't work. Is this for some
other product ?

Dave
>
> --Altaf
>
> Kris Jurka <books(at)ejurka(dot)com> wrote:
>
>
> On Fri, 27 Apr 2007, Altaf Malik wrote:
>
> > Hi, I encountered a bug with refcursors with the latest JDBC
> driver. I
> > cannot get two refcursors as OUT parameter if both of them point
> to the
> > same underlying refcursor.
> >
>
> Is this an actual problem or just something you came up with to
> make it
> fail? I don't see the use case here because the previous driver
> version
> would return the full ResultSet and then an empty one because
> everything
> had been fetched from it. So that would be pretty useless.
>
> Kris Jurka
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
> Ahhh...imagining that irresistible "new car" smell?
> Check out new cars at Yahoo! Autos.