Can't Generate Table with more than 10 Natural Key Columns

[GoogleCodeExporter]

What steps will reproduce the problem?

 -) Attempt to generate a schema with more than 10 natural key columns.  Note: NK columns exceed 10 when they are part of foreign key natural keys.

What is the expected output? What do you see instead?

 -) Instead of generating, the generation fails.

Please use labels and text to provide additional information.

 -) Increase the size of the tab_col_va_type varray in the "generate" package specification.

Original issue reported on code.google.com by Duane.Di...@gmail.com on 6 Jun 2012 at 6:51

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Increased from 10 to 100:

   TYPE tab_col_va_type IS VARRAY(100)   -- Array of 100 TAB_COLS%ROWTYPE
      OF tab_cols%rowtype;
   TYPE fk_tid_va_type IS VARRAY(100)   -- Array of 100 FK_TABLE_IDs
      OF tab_cols.fk_table_id%type;

   TYPE nk_aa_rec_type IS RECORD   -- A TABLES%ROWTYPE with 100 TAB_COLS%ROWTYPE
      (tbuff           tables%rowtype
      ,cbuff_va        tab_col_va_type
      ,lvl1_fk_tid_va  fk_tid_va_type
      );
   TYPE nk_aa_type IS TABLE       -- Associative Array of TABLES%ROWTYPE
      OF nk_aa_rec_type           --   Each of which have 100 TAB_COLS%ROWTYPE
      INDEX BY PLS_INTEGER;

Original comment by Duane.Di...@gmail.com on 16 Oct 2012 at 3:50