How to join a varray(20) type returned from a function with a table?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Apr 2001
    Posts
    125

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

    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

  2. #2
    Join Date
    Sep 2007
    Posts
    36
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width