During evaluation of Python 2.7 + SqlAlchemy 0.8.x using OracleDialect, I found most of the features I need exist out of the box; however I don't see a way to pass arrays as inputs to function calls.
Am I overlooking an existing capability? ... my searches have come up empty for Oracle but looks like Postgres has this already. In my situation, there are a number of existing custom types in the db defined like: "create or replace TYPE int_list AS TABLE OF INTEGER NOT NULL;" ... "create or replace TYPE str_list AS TABLE OF VARCHAR2(256 CHAR) NOT NULL;" These db types are typically expected as input parameters to functions. If support for this does not exist yet, I would be interested in adding support. It's unfortunately way beyond the scope of my task to modify the db to accommodate SqlAlchemy. I found the sqlalchemy user defined type support here: http://docs.sqlalchemy.org/en/rel_0_9/core/types.html#types-custom I also found what looks like underlying support for array types in cx_Oracle here: https://code.google.com/p/cx-oracle-demos/source/browse/trunk/todo/oracle-array.py?r=2 I don't see a way to plumb these cx_Oracle features into sqlalchemy user defined types since they depend on cx_Oracle connection and cursor types. Maybe there's a completely alternate approach I'm overlooking? Thanks in advance for suggestions. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
