Devart Forums

Code: Select all

using (OracleConnection conn = new OracleConnection(@"User Id=my_user;Password=my_pw;Server=prod-db;Direct=True;Sid=CORP01;Port=1526;Persist Security Info=True")) {                
conn.Direct = true;
await conn.OpenAsync();

var sql = @"
         insert into my_table ( SCODE ,PCODE ) 
         values (:col1, :col2 ) returning id into :output_id";
 
 OracleParameter outputParam = new OracleParameter()
 { 
     ParameterName = ":output_id",
     Direction = ParameterDirection.ReturnValue
 };
 OracleParameter[] parameters = new OracleParameter[]
 {     
     new OracleParameter(":col1", OracleDbType.VarChar,  v.SCODE, ParameterDirection.Input),
     new OracleParameter(":col2", OracleDbType.VarChar,  v.PCODE, ParameterDirection.Input),
     outputParam
 };


     var cmd = new OracleCommand(sql, conn);
     cmd.Parameters.AddRange(parameters);


     var vId = await cmd.ExecuteNonQueryAsync();
}