oracle nested table support

[Mike Bayer]

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:

1. 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.

2. build out an ARRAY type similar to that of Postgresql. We can use SchemaType here in a similar fashion.

[Mike Bayer]

this is some goofy fringe feature nobody needs...

[Mike Bayer]

there's definitely no plan to add this

[Kathir]

Is there a way to handle a PLSQL Table (Array of Objects) in Python?

[Mike Bayer]

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.

[Kathir]

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.