Number of Affected Rows

Is there a way to find out how many rows have been changed after an update; if you don't have the need for binding any DML statements or RETURNING clauses?

Example:
sqlText = "update abc set a = a + 5 where a < 4"

OCIStmtPrepare(stmthp, errhp, sqlText, strlen(sqlText), OCI_NTV_SYNTAX, OCI_DEFAULT);
OCIStmtExecute(svchp, stmthp, errhp, 1, 0, 0, 0, OCI_DEFAULT);
?OCIAttrGet(bindp2, OCI_HTYPE_BIND, &numberOfAffectedRows, sizeof(int),
???????, errhp);

thanks,

heidi (heidi_at_gestalt.com) Received on Wed Jun 24 1998 - 00:00:00 CDT