That will only have the number of rows once you have fetched them all.
Oracle doesn't know how many rows a query returns until all the results are
fetched.
Jim
"Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote in message
news:9kdrlt$81l$1_at_kermit.esat.net...
> What about v_rowcount := SQL%ROWCOUNT;
>
>
> Jim Kennedy wrote in message ...
> >Very expensive. You end up doing 2 queries of every one or retrieving
the
> >entire result set 2x.
> >Jim
> >"Isma" <Isma_at_iballo.com> wrote in message
> >news:3B6958BF.1B0AFF3F_at_iballo.com...
> >> Hi,
> >>
> >> I use a JDBC driver. I want to know whether exists a command to know
the
> >> results number just after the query.(i.e. lines)
> >>
> >> [I know it exists getColumnCount() to know the number of columns return
> >> ..
> >> int numcols = rsmd.getColumnCount();
> >> ]
> >>
> >> stmt.execute(sql)
> >> ResultSet rs = stmt.getResultSet();
> >> ResultSetMetaData rsmd = rs.getMetaData();
> >>
> >>
> >> What about getfetchSize() ??? it always return 10 whatever returned
> >> results.
> >>
> >>
> >
> >
>
>
Received on Fri Aug 03 2001 - 09:56:46 CDT
