We are using ADO.NET to connect to an Oracle 8i database
server. On application startup, we dynamically build data
adapters for all tables in our database, including
building our own custom SELECT, INSERT, UPDATE, and DELETE.

SELECT is done in code with embedded SQL, but the INSERT,
UPDATE and DELETE are done with Oracle stored procs.

We are trying to determine the number of records that are
affected by those stored procs, and everything I've found
seems to indicate that the only way to do that is to call
the OracleCommand.ExecuteNonQuery method.

Is there another way to get the number of rows affected
when calling an Oracle stored proc?

Thanks in advance,

Mike Lastort
lastort@speakeasy.net