1OracleConnection oConn = new OracleConnection(strConn);
2                try
3                {
4                    oConn.Open();
5                    OracleCommand oCmd = new OracleCommand(sSQL, oConn);
6                    oCmd.CommandText = sSQL;
7                    oCmd.CommandType = System.Data.CommandType.Text;
8                    oCmd.ExecuteStream();
9                }
10                catch (Exception ex) // catches any error
11                { Console.WriteLine(ex.Message.ToString()); }
12                finally
13                {
14                    oConn.Close();
15                    oConn.Dispose();
16                }