Can one get useful information from this?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

milkyway - 01 Sep 2005 00:25 GMT

Hello,

When one executes a query with OCIStmtExecute, is there a way to tell
the *number* of rows affected by the statment? Can an example be
provided as to how to get the number of rows affected by an insert /
update or delete statement executed through the OCIStmtExecute?

TIA

Reply to this Message

Andy Hassall - 01 Sep 2005 00:36 GMT

>When one executes a query with OCIStmtExecute, is there a way to tell
>the *number* of rows affected by the statment? Can an example be
>provided as to how to get the number of rows affected by an insert /
>update or delete statement executed through the OCIStmtExecute?

OCI_ATTR_ROW_COUNT statement handle attribute.
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14250/ociaahan.htm#i
428664

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Reply to this Message