Hi TOM,
I want to write an extract utility, which will get data from selected columns of multiple tables so planning to use pipeline function which will return a ORACLE TYPE.

To create type, I would like give reference of column type from source table as below -

CREATE OR REPLACE TYPE mytype AS OBJECT (
  COL1  SOURCETAB1.COL1%TYPE,
  COL2 SOURCETAB2.COL2%TYPE,
  COL3 SOURCETAB3.COL3%TYPE
);

But this throws an error and does not allow to create this type. I do not want to give hardcode datatype in this object to avoid maintains issue.

Please suggest on this. thanks.