gistfile1.txt

  (j/with-db-connection [conn oracle-db]
    (with-open [stmt (.prepareCall (j/get-connection conn) "{ call dbms_pipe.pack_message(?) }")]
      (doto stmt
        (.setString 1 "Testing testing")
        (.execute))
     )

    (with-open [stmt (.prepareCall (j/get-connection conn) "{? = call dbms_pipe.send_message('pipename') }")]
    (doto stmt
      (.registerOutParameter 1 java.sql.Types/INTEGER)
      (.execute))        
    (. stmt getObject 1))
  )