Hi,

I have a type defined as follows:

CREATE OR REPLACE TYPE type1 IS varray(20) of varchar2(20)

And I have a function func1 use type1 as return value. I try to join the return value with a table, how can I do so?



The following ways are not working:

select *
FROM tab2, (select func1('abc') col1 from dual) tab1
WHERE tab2.col2 = TO_CHAR(tab1.col1)

select * from tab2 where tab2.col2 in (select func1('abc') col1 from dual)

Thanks a lot