62
Views
8
Comments
How can I getting total affected row in advanced "UPDATE" query by Oracle
Question

Hi

how can I getting total affected row in advanced "UPDATE" or "INPUT" query by Oracle?

Thanks in advance.

Regards

mvp_badge
MVP
Rank: #19

Hi Lucas,

Use Select @@RowCount and an Output parameter of data type int.

Use an input parameter RowCount of data type text and set it to "@@ROWCOUNT"

The assumption here is you use MS SQL Server, if it is Oracle you use let me know, I have to look that up, don't use Oracle myself.

Regards,

Daniel

mvp_badge
MVP
Rank: #19

Hi, try  for Oracle "sql%rowcount" as the input parameter value. 

mvp_badge
MVP
Rank: #19

Do you have the property Expand Inline Parameters set to True?

See the screenshot I shared originally.

mvp_badge
MVP
Rank: #19

Hmm... problem is I don't have Oracle and are not an Oracle specialist.

Either way, the trick is the Inline Parameter and SELECT statement with output parameter and the right Oracle syntax. Hope you can google yourself to a working SQL clause.

Rank: #406