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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center