Re: OCI 8.1.6: query rows counts?

From: Sergei Kuchin <skuchin_at_sprynet.com>
Date: Wed, 05 Apr 2000 05:14:57 -0500
Message-ID: <38EB1221.1823@sprynet.com>

ub4 rpc(void)
 {sb4 rpc;
  status=OCIAttrGet

   ((dvoid *)cda, 
    (ub4)OCI_HTYPE_STMT, 
    (dvoid *) &rpc, 
    (ub4 *) 0, 
    (ub4)OCI_ATTR_ROW_COUNT, 

    errhp);
  if(status)return 0;
  return rpc;
 }

where cda is the statement handle.

Sergei

Snarf Man wrote:
>
> Hello,
> I am using Oracle 8.1.6 OCI stuff.
>
> I have a query statement that looks something like
>
> select a, b from c where a like 'something%';
>
> If I set 'iters' in OCIStmtExecute() to say 10 and there are only
> 8 matches in the DB, OCIStmtExecute() returns OCI_NO_DATA. Bummer.
>
> If I set 'iters' to 1, then I get them all.
>
> Is there a way to determine how many rows matched they query without
> having to do two queries?
>
> --
>
> ---------------------------------------------------------
> Mark Crosland
> Remove the leading and trailing 00 from reply-to address.
> ---------------------------------------------------------
Received on Wed Apr 05 2000 - 05:14:57 CDT