.net核心调用oracle函数将返回值放入第一个参数

using Oracle.ManagedDataAccess.Client;

public class OracleFunctionCaller
{
    public void CallOracleFunction()
    {
        string connectionString = "Data Source=your_database_address;User Id=your_username;Password=your_password;";
        
        using (OracleConnection connection = new OracleConnection(connectionString))
        {
            connection.Open();
            
            using (OracleCommand command = connection.CreateCommand())
            {
                command.CommandText = "CALL your_oracle_function(:param1, :param2)";
                
                // 设置第一个参数为返回值
                OracleParameter returnValueParam = new OracleParameter("param1", OracleDbType.Varchar2);
                returnValueParam.Direction = ParameterDirection.ReturnValue;
                command.Parameters.Add(returnValueParam);
                
                // 设置其他参数
                OracleParameter param2 = new OracleParameter("param2", OracleDbType.Varchar2);
                param2.Value = "your_parameter_value";
                command.Parameters.Add(param2);
                
                command.ExecuteNonQuery();
                
                // 获取返回值
                string returnValue = command.Parameters["param1"].Value.ToString();
                
                // 使用返回值进行后续操作
                // ...
            }
            
            connection.Close();
        }
    }
}