Number of rows update Oracle 8i -using ADO
I am using a stored procedure with DBMS_SQL to update a table based on
some parameters entered via a form.
My question is :
How can I Check to see how many rows were updated.
in 7.3 there was function SQL%rowcount that could be used.
in 8i, using DBMS_SQL is there a way to check the number of rows updated
after using the DBMS_SQL.EXECUTE function.
For example can i get the number of rows updated into the returning
clause of a DML statement.
eg "UPDATE tblY SET val1 = 'TEST' where val2 = 'TESTCASE' RETURNING
rownum into :v_out"
This is an example only. where v_out is bind variable.
Any help is appreciated.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL