If I wanted to find the number of rows updated in a query in sql server i just do my update then do a select on the @@identity column.
<cfquery name="qUpdate" datasource="#dsn#">
update table a
set column1 = bla
where column2 = 1
select @@identity as noOfRowsUpdated
I can then get the result by accessing qUpdate.noOfRowsUpdated.
However in Oracle @@identity does not exist. They do however have row%count. Does anyone know how to get this to work properly or is there a more simple / elegant solution?
Thanks in advance,
Europe, Middle East and Africa