Re: Problem with ROWNUM and REF CURSOR

From: <svardhan_at_cordys.com>
Date: Thu, 22 Nov 2012 01:26:32 -0800 (PST)
Message-ID: <3d54713c-9b7c-4d4e-8140-0faca0242156_at_googlegroups.com>

Instead of CURSOR_NAME%NOTFOUND use CURSOR_NAME%COUNT=0; On Friday, June 16, 2000 12:30:00 PM UTC+5:30, gia..._at_my-deja.com wrote:
> I have a stored procedure that returns a
> ref cursor using a query like this:
>
> open rc for select
> /* BIG QUERY */
> where rownum < 11;
>
> where rc is a ref cursor variable.
>
> At the client side I can fetch the first 10 rows
> quickly, but the 11th fetch (that yelds NOTFOUND)
> is very very slow.
>
> Could anyone help me?!
>
> Thank You!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 22 2012 - 10:26:32 CET