Support Oracle bind parameter value for Oracle12 visitor

2 files changed, 17 insertions, 2 deletions

diff --git a/lib/arel/visitors/oracle12.rb b/lib/arel/visitors/oracle12.rb
index 4a42343c9b..0711e70df7 100644
--- a/lib/arel/visitors/oracle12.rb
+++ b/lib/arel/visitors/oracle12.rb
@@ -48,6 +48,10 @@ module Arel
 
         super
       end
+
+      def visit_Arel_Nodes_BindParam o, collector
+        collector.add_bind(o) { |i| ":a#{i}" }
+      end
     end
   end
 end
diff --git a/test/visitors/test_oracle12.rb b/test/visitors/test_oracle12.rb
index df0f01b30b..d6fbf8912b 100644
--- a/test/visitors/test_oracle12.rb
+++ b/test/visitors/test_oracle12.rb
@@ -2,9 +2,10 @@ require 'helper'
 
 module Arel
   module Visitors
-    describe 'the oracle visitor' do
+    describe 'the oracle12 visitor' do
       before do
-        @visitor = Oracle12.new Table.engine.connection_pool
+        @visitor = Oracle12.new Table.engine.connection
+        @table = Table.new(:users)
       end
 
       def compile node
@@ -42,6 +43,16 @@ module Arel
           compile(node).must_be_like "FOR UPDATE"
         end
       end
+
+      describe "Nodes::BindParam" do
+        it "increments each bind param" do
+          query = @table[:name].eq(Arel::Nodes::BindParam.new)
+            .and(@table[:id].eq(Arel::Nodes::BindParam.new))
+          compile(query).must_be_like %{
+            "users"."name" = :a1 AND "users"."id" = :a2
+          }
+        end
+      end
     end
   end
 end