Here's how I do it with clojure.java.jdbc:
(defn do-stored
"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 (sql/connection) sql)]
(doseq [param-group param-groups]
(doseq [[index value] (map vector (iterate inc 1) param-group)]
(.setObject stmt index value))
(.addBatch stmt))
(sql/transaction
(seq (.executeBatch stmt)))))
(defn insert-sample-log
[process-code
csid
sample-id
container-id
container-well
tube-barcode
username
comment]
(do-stored "{call
bsms_owner.Add_Sample_Log(?, ?, ?, ?, ?, ?, ?, ?)}"
[process-code
csid
sample-id
container-id
container-well
tube-barcode
username
comment]))
Hope that helps.
Cheers,
Willy
On Nov 19, 3:14 pm, Ghadi Shayban <[email protected]> wrote:
> I'm trying to load and execute an Oracle Java Stored Procedure...
> written in Clojure.
>
> Has anyone successfully managed to do this? Are you done throwing
> up? I would appreciate any direction
>
> I have a little clj that is AOT compiled, and I load the whole jar
> into the DB successfully.
>
> What I'm running into is half of the classfiles inside clojure.jar
> including RT get marked as invalid by the database class "resolver".
> They have a 30-char max on pkg/class names, and anything longer gets
> entered into a lookup table.
>
> This seems to be a good
> referencehttp://download.oracle.com/docs/cd/E11882_01/java.112/e10588/chtwo.ht...
>
> I'm not too familiar with custom class loaders, and I'm not sure
> that's what I'd need.
--
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
