JDBC does not support named parameters in SQL queries. However, support for them has been implemented in Spring framework. This library implements a simple way to use this feature from Clojure with Oracle database. Only queries are supported. The library can be found here.

(ns oracle-namedparam-test.core
  (:require [clj-oracle-namedparameters.core :as db]))

(db/query "select table_name, num_rows from user_tables
           where num_rows > :min_rows
           order by num_rows desc"
          {:min_rows 100})