cx-oracle-users

[cx-oracle-users] arrays outside of plsql

[Amos S. <as...@as...>]

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)?

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
>

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

[Amos S. <as...@as...>]

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" <ant...@gm...>
To: cx-...@li...
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 < 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 


------------------------------------------------------------------------------
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-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users