"out" parameters for oracle

this will look like so:

   o1 = outparam("foo")
   o2 = outparam("bar")

   func.myfunc(3, 4, o1, o2).execute()

or

   func.myfunc(3, 4, bindparam("foo"), bindparam("bar")).execute(foo=o1, bar=o2)

then the result

   v1 = o1.value()
   v2 = o2.value()

is there a better way ? keep in mind the outparam is stateful so the approach of embedding it straight in the func, which normally should support multiple operations/multithreaded operation is not the general solution, the second form is.

Comments (2)