How to join a varray(20) type returned from a function with a table?

[zxmgh]

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

[jay_l_a]

Can you give a little background on what you are trying to achieve?

It may be possible to do what you are trying, but there may be a better way.
J