Select filtering on table of varchar2
699809May 5 2009 — edited May 5 2009Hi, i'm trying to do this in a PL/SQL procedure:
SELECT mytbl.id, mytbl.val
FROM mytbl
WHERE mytbl.id IN names
where names is declared as:
TYPE type_names IS TABLE OF VARCHAR2 INDEX BY pls_integer;
names type_names;
I get error "table or view not exists"
I have tryed also with "... IN TABLE(names)" and i get "cannot access rows from a non-nested table item".
Can anyone help me?
Thanks