Re: [cx-oracle-users] arrays outside of plsql

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

Hi,

No, there are no known obstacles other than a lack of time. :-) I've been
wanting to implement this for a few years now....but since I don't need it
for my job it hasn't been a priority. :-( If you want to pursue this I'm
more than willing to accept patches!

Anthony


On Thu, Jan 30, 2014 at 9:44 AM, Amos Smith <as...@as...> wrote:

> I would like to call db functions that expect array types as input via
> cx_Oracle.
>
> When I try to do this currently I get the error message:
> ORA-01484: arrays can only be bound to PL/SQL statements
>
> I have seen the examples of how to make this work within PL/SQL statements
> but my goal is to interact with the database via SqlAlchemy user defined
> types ... such that I can't wrap the command in PL/SQL.
>
> I implemented a similar capability in our JDBC based clients using
> OracleConnection to create ARRAY type.
>
> Are there known obstacles to having a feature like this via cx_Oracle (and
> implicitly DBAPI)?
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends.  Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>