oracle nested table support

Issue #2925 wontfix
Michael 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 (5)

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

  2. Log in to comment