James DeMond <demond(at)cs(dot)dal(dot)ca> writes:
> What I'm trying to do is this:
>
> create type MYSCHEMA.T_QUESTION_RESULT as (
> IND_QUESTION NUMERIC,
> N_ANSWER NUMERIC
> );
>
> create type MYSCHEMA.T_QUESTION_RESULT_LIST as (
> col1 MYSCHMA.T_QUESTION_RESULT[]
> );
We don't support arrays of composite types at the moment.
> Truth be told, I'm actually trying to port this from some definitions I
> have from Oracle which look like this:
>
> create or replace type MYSCHEMA.T_QUESTION_RESULT as object (
> IND_QUESTION number,
> N_ANSWER number
> );
>
> create or replace type MYSCHEMA.T_QUESTION_RESULT_LIST as table of
> T_QUESTION_RESULT;
I'm not sure what Oracle thinks the latter construct really means?
Perhaps you shouldn't be trying to map it into an array.
regards, tom lane