C# Oracle -按顺序执行存储过程

using System;
using Oracle.ManagedDataAccess.Client;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=your_database;User Id=your_username;Password=your_password;";

        using (OracleConnection connection = new OracleConnection(connectionString))
        {
            connection.Open();

            // 创建存储过程对象
            OracleCommand command = new OracleCommand("your_stored_procedure", connection);
            command.CommandType = System.Data.CommandType.StoredProcedure;

            // 设置存储过程参数
            command.Parameters.Add("input_param1", OracleDbType.Varchar2).Value = "value1";
            command.Parameters.Add("input_param2", OracleDbType.Int32).Value = 123;
            command.Parameters.Add("output_param", OracleDbType.Varchar2, 100).Direction = System.Data.ParameterDirection.Output;

            // 执行存储过程
            command.ExecuteNonQuery();

            // 获取输出参数的值
            string outputValue = command.Parameters["output_param"].Value.ToString();
            Console.WriteLine("Output parameter value: " + outputValue);
        }
    }
}