Issues

Issue #2925 wontfix

oracle nested table support

Mike Bayer
repo owner created an issue

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.

Comments (2)

  1. Log in to comment