Hi,

I have a need to work with a collection of composite data type with more than 1000 columns in it.

Here is the sample code below for collection with composite data type of 2 columns.

CREATE OR REPLACE TYPE obj_typ1 AS OBJECT (col1 number, col2 NUMBER);

CREATE OR REPLACE TYPE col_typ1 AS table OF obj_typ1;


DECLARE
var_typ col_typ1;
BEGIN
  SELECT obj_typ1(1,2) INTO var_typ FROM (SELECT 1,2 from dual);
END; 

When I increase the number to more than 1000 I get a ORA-00939: too many arguments for function ERROR

CREATE OR REPLACE TYPE obj_typ1 AS OBJECT (col1 number, col2 NUMBER......... col1000 NUMBER);

CREATE OR REPLACE TYPE col_typ1 AS table OF obj_typ1;


DECLARE
var_typ col_typ1;
BEGIN
  SELECT obj_typ1(1,2.....1000) INTO var_typ FROM dual;
END; 

A select list can contain more than 1000 columns and an Object Type can contain more than 1000 columns, but I am not able to populate that collection from the Select statement when the count is more than 1000 for the column list.

Is there a work around for this?

Thanks!

DECLARE
  var_typ col_typ;
BEGIN
  var_typ := col_typ(obj_typ(1,2,...,999,1000));
END;
/