Re: New features?

On Thu, Jan 28, 2016 at 2:52 AM, Walter Dörwald <[email protected]>
wrote:

> On 27 Jan 2016, at 17:21, Anthony Tuininga wrote:
>
> > All,
> >
> > I have recently been able to spend a bit more time on cx_Oracle and
> > would
> > like your feedback on what features would be of the greatest benefit
> > to
> > you. Besides the ones that are in 5.2.1, the following features have
> > been
> > committed:
> >
> > Added support for pickling/unpickling error objects
> > Added support for getting implicit results (Oracle Database 12.1)
> > Added support for Transaction Guard (Oracle Database 12.1)
> > Added support for setting max lifetime session of pool (Oracle
> > Database
> > 12.1)
> >
> > Any and all feedback appreciated.
> >
> > Anthony
>
> We have many procedures which have a parameter with type INTEGERS, which
> is defined as:
>
>     create or replace type integers as table of integer;
>
> I'd like to by able to such a procedure through cx_Oracle.
>

This can now be done with the code in the source repository today.

typeObj = connection.gettype("integers")
obj = typeObj.newobject()
obj.extend([1, 2, 3, 4])
cursor = connection.cursor()
cursor.callproc("someprocedure", (obj,))

Anthony

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users