如何在c#中编写oracle insert查询返回值？

using Oracle.ManagedDataAccess.Client;

string connectionString = "Data Source=your_database;User Id=your_username;Password=your_password;";
using (OracleConnection connection = new OracleConnection(connectionString))
{
    connection.Open();
    // 编写INSERT查询语句
    string sql = "INSERT INTO your_table (column1, column2) VALUES (:value1, :value2) RETURNING id INTO :insertedId";
    
    // 创建OracleCommand对象
    using (OracleCommand command = new OracleCommand(sql, connection))
    {
        // 设置参数值
        command.Parameters.Add(":value1", OracleDbType.Varchar2).Value = "value1";
        command.Parameters.Add(":value2", OracleDbType.Varchar2).Value = "value2";
        command.Parameters.Add(":insertedId", OracleDbType.Int32).Direction = ParameterDirection.Output;
        
        // 执行查询并返回插入的ID值
        command.ExecuteNonQuery();
        int insertedId = Convert.ToInt32(command.Parameters[":insertedId"].Value);
        
        // 使用插入的ID值进行后续操作
        // ...
    }
}