Берем такой кусок кода (консольное приложение).
Код: Выделить всё
IDbConnection conn = null;
conn = new Devart.Data.Oracle.OracleConnection("User Id=*;Password=*;Server=*");
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "DECLARE v NUMBER; BEGIN SELECT 1 INTO v FROM dual WHERE 1=2; END;";
conn.Open();
try
{
cmd.ExecuteNonQuery();
Console.WriteLine("Ok ");
}
catch (Exception e)
{
Console.WriteLine("Error " + e.Message + "\n" + e.StackTrace);
}