public void test(string connectStr)
{ 
      using (OracleConnection connection = new OracleConnection(connectStr))
      {
          connection.Open();
          OracleCommand sqlCmd = new OracleCommand("GETSEQUENCE", connection);

          OracleParameter[] parameters = new OracleParameter[2];
          parameters[0] = new OracleParameter(":SEQ_NAME", OracleDbType.Varchar2) { Value = "SEQ", Direction = System.Data.ParameterDirection.Input };
          parameters[1] = new OracleParameter(":SEQ_VALUE", OracleDbType.Int32) { Direction = System.Data.ParameterDirection.Output };
          sqlCmd.Parameters.AddRange(parameters);
          sqlCmd.CommandType = CommandType.StoredProcedure;//设置 使用存储过程
          sqlCmd.ExecuteNonQuery();
          int obj = Convert.ToInt32(parameters[1].Value.ToString());
          connection.Close();

          System.Console.WriteLine(obj);
      }
  }

public int test(string connectStr)
{

    var ParaSeqName = new OracleParameter("SEQ_NAME", OracleDbType.Varchar2, SeqName, ParameterDirection.Input);
    var ParaSeqValue = new OracleParameter("SEQ_VALUE", OracleDbType.Int32, ParameterDirection.Output);
    var strSQL = "BEGIN GETSEQUENCE(:SEQ_NAME,:SEQ_VALUE); END;";
    var result = base.DbContext.Database.ExecuteSqlCommand(strSQL, ParaSeqName, ParaSeqValue);
    if (result != -1)
    {
        _logger.LogError($"End; Orcacle error code:{result}");
        return 0;
    }
           
    OracleDecimal ret = (OracleDecimal)ParaSeqValue.Value;

    Int32 orderNo = ret.IsNull ? 0 : ret.ToInt32();
    return orderNo;
}