PL/SQL (MOSC)

MOSC Banner

Using Multiple Casting of collection type - Join them

edited Mar 18, 2010 3:15AM in PL/SQL (MOSC) 5 commentsAnswered
 I have the following:

create type WMI_ARRAY_NTT AS TABLE OF VARCHAR2(32767)

Cursor is
SELECT a.COLUMN_VALUE itemnumber
            ,b.cu_id
            ,c.COLUMN_VALUE shortdesc
      FROM   TABLE (CAST (v_item_numbers AS wmi_array_ntt)) a
            ,unit_assembly b
            ,TABLE (CAST (v_item_descriptions AS wmi_array_ntt)) c
      WHERE  1 = 1
      AND    b.assembly_item_id = a.COLUMN_VALUE
      AND    a.ROWID = c.ROWID;

I get runtime error saying that rowid is not valid. How do I join these casted collections?

Thanks

Andy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center