Re: Number of Affected Rows

From: lange Francois <flange_at_pt.lu>
Date: 1998/06/25
Message-ID: <01bda02a$5c383520$5bd69ac2@fran-ois>#1/1

Hi,
For an update/delete the information about the number of row affected is stored in the cda structure

struct Lda_Def cda {

	...
	rpc		Rows Processed.
	...

}

-- 
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg.
Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between
France,Germany and Belgium.
Heidi K. Barg <heidi_at_stepforward.org> wrote in article
<6mrmom$40v$1_at_cleavage.canuck.com>...


> 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 Thu Jun 25 1998 - 00:00:00 CDT