SQL & PL/SQL

Hi All,

Is there any way to merge the two INDEX BY tables?

i tried MULTISET UNION DISTINCT from the below link:
http://www.oracle.com/technology/oramag/oracle/03-sep/o53plsql.html

I got the PLS:00306: wrong number or types of arguments in call to 'MULTISET_UNION_DISTINCT' error.

Code:

declare

TYPE rec_nbrchk IS TABLE OF test.rec_nbr%TYPE
INDEX BY BINARY_INTEGER;

rec_nbr_chk rec_nbrchk;
mlcl_scope_chk rec_nbrchk;
all_chk rec_nbrchk;

begin

all_chk := (rec_nbr_chk )
MULTISET UNION DISTINCT
(scope_chk);
end;

Thanks in advance.

Suresh.