ReturningInto4

 public long InsertParameter(string paramName, string paramDescription)
        {
            using (var connection = new OracleConnection(ConnectionString))
            {
                connection.Open();

                var sqlText = "Insert into Parameters (name, description) values (:paramName, :paramDescription) RETURNING ID INTO :nextId";

                using (var command = new OracleCommand(sqlText, connection)
                {
                    CommandType = CommandType.Text,
                    BindByName = true,
                })
                {
                    command.Parameters.Add(
                        new OracleParameter("nextId", OracleDbType.Decimal, sizeof(long))
                        {
                            Direction = ParameterDirection.ReturnValue
                        });

                    command.Parameters.Add(new OracleParameter(":paramName", OracleDbType.Varchar2) { Value = paramName });
                    command.Parameters.Add(new OracleParameter(":paramDescription", OracleDbType.Varchar2) { Value = paramDescription });

                    command.ExecuteNonQuery();
                    object returnedValue = command.Parameters["nextId"].Value;
                    if (returnedValue == null)
                        return 0;

                    OracleDecimal decimalValue = (OracleDecimal)returnedValue;
                    return decimalValue.IsNull ? 0 : decimalValue.ToInt64();
                }
            }
        }