We are using the Managed Driver (version 4.121.2.0) to call some stored procedures. It worked fine until the stored procedure threw exceptions using RAISE_APPLICATION_ERROR. If exceptions were thrown in the stored proc, ExecuteNonQuery would hang. This did not occur with the un-managed driver.
This looks like a bug to me, does anyone know how to get around it in the short term?
Code:
=========================
using Oracle.ManagedDataAccess.Client;
... ...
OracleCommand cmd = new OracleCommand("stored_proc", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.ExecuteNonQuery(); // Hangs if stored_proc RAISE_APPLICATION_ERROR(-20000,'ERROR!!!');
... ...