All,
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.
Thanks

Jawahar