Re: Using vaarray in dynamic sql - ORA-00904: invalid identifier

  PROCEDURE testmemberofprc(

            po_ref_cursor OUT RefCursor)   IS
    --TYPE alc_tab IS TABLE OF aggregatelevelright.aggregatelevelcode %TYPE INDEX BY PLS_INTEGER;
    ntt type_varchar2_4000;

    v_sql VARCHAR2(2000);
    v_errcode VARCHAR2(2000);

  BEGIN     ntt := type_varchar2_4000('A', 'B', 'C');

    v_sql := 'SELECT ks_varchar2 ' ||


             'FROM   ks ' ||

             'WHERE  ks_varchar2 MEMBER OF :ntt ';


    OPEN po_ref_Cursor FOR v_sql USING ntt;

  EXCEPTION
  WHEN OTHERS

       THEN
       v_errcode := Sqlerrm;
       RAISE;