Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 05:30:57 CDT