Re: [cx-oracle-users] New features?

[Anthony T. <ant...@gm...>]

On Thu, Jan 28, 2016 at 2:52 AM, Walter Dörwald <wa...@li...>
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