Re: arrays outside of plsql

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 <[email protected]> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk

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