OCI 8: total num of rows.

From: Daniel Okine <daniel_okine_at_hp.com>
Date: Wed, 26 May 1999 14:28:39 +0100
Message-ID: <374BF707.36743D52@hp.com>

Hi,

Is there a simpler way of finding the total number of rows a statement would return without having to fetch and count all of them. I am thinking in terms of using OCIParamGet() and OCIAttrGet().

I am currently trying out the attribute "OCI_ATTR_ROWS_RETURNED" but l doubt if that will achieve what l want. Any help or hint will be greatly appreciated.

Daniel

--

---

            __
           / /\      Daniel R. Okine, Hewlett-Packard
 __       / /  \     HP Telnet: 315-3432      HP UK   : 53432
/_/\  __ /_/ /\ \    Tel (UK) : 01344-763432  Tel (INT):+44-1344-763432
\ \ \/ /\\ \ \ \ \   Fax(UK)  : 01344-763721  Fax (INT):+44-1344-763721
 \ \ \/  \\ \ \/ /   OpenMail : Daniel Okine /HP-Pinewood,om1

  \ \ \/\ \\ \ / Internet : daniel_okine_at_hp.com    \ \ \ \ \\ \ \ X.400 : C=GB;ADMD=400NET;P=HP;O=HP;

    \ \ \ \ \\ \ \              OU=HP-Pinewood;S=Okine;G=Daniel
     \ \ \_\/ \ \ \  Postal   : Hewlett-Packard Ltd, Nine Mile Ride,
      \ \ \    \_\/             Wokingham, Berks, RG40 3LL, UK
       \_\/
                      WWW : http://www.geocities.com/TheTropics/5761/




************************************************************************

Received on Wed May 26 1999 - 08:28:39 CDT