- changed milestone to blue sky
- edited description
oracle nested table support
see:
http://www.orafaq.com/wiki/NESTED_TABLE
example:
SQL> create or replace type str_list as table of varchar2(256 char) not null;
2 /
create table foo (id integer primary key, data str_list) nested table data store as data_tab;
SQL> insert into foo (id, data) values (1, str_list('a', 'b', 'c'));
1 row created.
SQL> select * from foo;
ID
----------
DATA
--------------------------------------------------------------------------------
1
STR_LIST('a', 'b', 'c')
steps needed:
-
get the above sequence to work in Python - cx_oracle must have some way to get the data in and out. If cx_oracle doesnt' support custom types directly, see if string formatting can be used. however bound parameters must be used.
-
build out an ARRAY type similar to that of Postgresql. We can use SchemaType here in a similar fashion.
Comments (5)
-
reporter -
reporter - changed status to wontfix
there's definitely no plan to add this
-
Is there a way to handle a PLSQL Table (Array of Objects) in Python?
-
reporter I'd approach this first from the cx_Oracle driver perspective. See http://cx-oracle.readthedocs.io/en/latest/index.html. If you can get what you want going there, then integrating w/ SQLAlchemy via extensions or plugins is the next step.
-
Thanks Mike for the info, the link was descriptive on cx_Oracle but even with that info , Im able to print only the Objects but not the elements of the object.
- Log in to comment
this is some goofy fringe feature nobody needs...