Hello,
I wanted to recommend the following method be added to
clojure.contrib.sql (stolen directly from do-prepared). I have used it
successfully with Oracle stored procedure calls. Please let me know if
I'm not posting to the right place or in the right manner or any
improvements that can be made.
Thanks.
(defn do-callable
"Executes an (optionally parameterized) SQL callable statement on
the
open database connection. Each param-group is a seq of values for
all of
the parameters."
[sql & param-groups]
(with-open [stmt (.prepareCall (connection) sql)]
(doseq [param-group param-groups]
(doseq [[index value] (map vector (iterate inc 1) param-group)]
(.setObject stmt index value))
(.addBatch stmt))
(transaction
(seq (.executeBatch stmt)))))
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
-~----------~----~----~----~------~----~------~--~---
