Re: arrays outside of plsql
Amos Smith <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
This ARRAY support feature is more of a "desirement" than requirement for us but I can probably put some time into this. Any suggestions or guidance as to what patterns or examples to follow would be most appreciated. ----- Original Message ----- From: "Anthony Tuininga" <[email protected]> To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org Sent: Monday, February 3, 2014 8:55:14 PM Subject: Re: [cx-oracle-users] 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 ------------------------------------------------------------------------------ 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