Re: Is there another way (Was: benchmarking, which statement is faster

On Tue, 31 Jul 2001 23:00:48 -0400, Phil Singer
<psinger1_at_chartermi.net> wrote:

In your case, insert this between the <g_flag = '1';> and the
<EXCEPTION> lines:

if (SQL%ROWCOUNT = whatever rows you're after) then   do whatever you want in that case;
end if;

Ooops, I meant, in the fetch loop. Immediate SQL doesn't return more than one row or else you get "too_many_rows" exception. Sorryboutdat!

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Aug 01 2001 - 12:30:57 CEST