C#：执行带有输入和输出参数的Oracle存储过程并将输出参数返回

下面是一个示例代码，展示了如何在C#中执行带有输入和输出参数的Oracle存储过程，并将输出参数返回：

using System;
using Oracle.ManagedDataAccess.Client;

class Program
{
    static void Main()
    {
        string connectionString = "YourOracleConnectionString";

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

            using (OracleCommand command = connection.CreateCommand())
            {
                command.CommandText = "YourStoredProcedureName";
                command.CommandType = System.Data.CommandType.StoredProcedure;

                // 添加输入参数
                OracleParameter inputParameter = new OracleParameter();
                inputParameter.ParameterName = "inputParamName";
                inputParameter.OracleDbType = OracleDbType.Varchar2;
                inputParameter.Value = "inputParamValue";
                inputParameter.Direction = System.Data.ParameterDirection.Input;
                command.Parameters.Add(inputParameter);

                // 添加输出参数
                OracleParameter outputParameter = new OracleParameter();
                outputParameter.ParameterName = "outputParamName";
                outputParameter.OracleDbType = OracleDbType.Varchar2;
                outputParameter.Size = 100; // 设置输出参数的大小
                outputParameter.Direction = System.Data.ParameterDirection.Output;
                command.Parameters.Add(outputParameter);

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

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

请确保将 YourOracleConnectionString 替换为实际的Oracle数据库连接字符串，将 YourStoredProcedureName 替换为实际的存储过程名称，inputParamName 和 inputParamValue 替换为实际的输入参数名称和值，outputParamName 替换为实际的输出参数名称。