I have the following type
type TVarcharArr is table of varchar(4000) index by binary_integer;
I have a procedure that passes in two separate arrays as:
p_account_number in TVarcharArr,
p_product_system_code in TVarcharArr
These arrays are related (they will have the same number of elements), the contents would be as follows:
Account Number Product System Code
123 ABC
456 DEF
789 GHI
I can use TABLE(CAST to turn each of these arrays into a table, but how do I join these two arrays together so that they become a single table with two columns? Or if I CAST them as TABLEs, how can I join these two tables together - is there some way of using the index to facilitate the join?
Cheers
Richard