Re: Return number of rows on OCI

From: Konstantin Kivi <konst_at_sirena.rinet.ru>
Date: 1997/10/27
Message-ID: <EIpyqL.Aq.0.debian@sirena.rinet.ru>#1/1

Gee M Wong <gwong_at_erols.com> wrote:
> I can not recall the name of the element, but the count is returned in
> the structure sqlca.

> On Thu, 23 Oct 1997 13:59:05 -0400, Eric Shiau <eshiau_at_dbna.com>
> wrote:

sqlca is Pro*C structure

> >On Oracle Call Interfaces applications, is any way to know how many
> >rows will be returned before you do oftech??

I think it's impossible to find out number of rows before actual fetch, unless you issue 'select count(*) from ... where ...' prior to your original query

Konstantin Received on Mon Oct 27 1997 - 00:00:00 CST