Oracle stored proc fails without raising exception

[lebb]

the rows would not be available to see to other sesisons until a commit

Can you confirm that this is a change in behavior with the Oracle 10g client and/or the 10g version of ODP.NET? Because, as I mentioned, the rows affected returns the expected value on stations with only the 9i client installed.

Are you sure that the same session is doing both?

Yes.