OCI 8.1.6: query rows counts?

From: Snarf Man <notMe_at_over.there.com>
Date: Wed, 05 Apr 2000 05:31:31 GMT
Message-Id: <slrn8eljti.np5.notMe@c1000907-b.sttls1.wa.home.com>

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 - 00:31:31 CDT