Devart Forums

Code: Select all

            
OracleConnection conn = new OracleConnection("User Id=TESTUSER;Password=TESTPASSWORD;Server=TESTSERVER");
            //OracleConnection conn = new OracleConnection("User Id=TESTUSER;Password=TESTPASSWORD;Server=server1.test.com;Direct=True;Sid=TESTSERVER;Port=1521;");
            conn.Open();

            OracleCommand cmd = conn.CreateCommand();

            try
            {
                cmd.CommandText = "DROP TABLE DEVARTBULKLOAD";
                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
            }

            try
            {
                cmd.CommandText = "create table devartBulkLoad (colA varchar2(100 BYTE), colB number(10,2), colC varchar2(100 BYTE))";
                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
            }

            OracleCommand bulkCommand = conn.CreateCommand();
            bulkCommand.CommandText = "insert into devartbulkload (cola,colb,colc) values (:cola,:colb,:colc)";

            OracleParameter par1 = new OracleParameter("COLA", OracleDbType.VarChar);
            par1.IsNullable = true;
            object[] paramValues = new object[2];
            paramValues[0] = null;
            paramValues[1] = null;
            par1.Value = paramValues;
            bulkCommand.Parameters.Add(par1);

            OracleParameter par2 = new OracleParameter("COLB", OracleDbType.Number);
            par2.IsNullable = true;
            paramValues = new object[2];
            paramValues[0] = 3;
            paramValues[1] = 2;
            par2.Value = paramValues;
            bulkCommand.Parameters.Add(par2);

            OracleParameter par3 = new OracleParameter("COLC", OracleDbType.VarChar);
            par3.IsNullable = true;
            paramValues = new object[2];
            paramValues[0] = "foo";
            paramValues[1] = "bar";
            par3.Value = paramValues;
            bulkCommand.Parameters.Add(par3);

            bulkCommand.ExecuteArray(2);