title: oracle sql varray contains an element
body: <p>I have a type declaration like this:</p>
  
  <pre><code>  FUNCTION ...
    IS 
       TYPE stati_va IS VARRAY (10000) OF varchar(1);
       stati       stati_va;
       v_counter   INTEGER  := 0;
    BEGIN
        stati := stati_va ();
  
        --this is actually in a loop so the array contains more values
        v_counter := v_counter + 1;
        stati.EXTEND;
        stati (v_counter) := '4';
  
  
        --here I would like to determine if the array 'stati' contains a value
  </code></pre>
  
  <p>I have tried the following so far but that gives me an errro</p>
  
  <pre><code>      IF '4' member of stati then  &lt;- COMPILE error
        IF '4' IN stati then         &lt;- COMPILE error
  </code></pre>
  
  <p>I know that looping through the array would be possible but that is a bit inconvinient since I need to build something like this:</p>
  
  <pre><code>     IF array contains '4' then
       elsif array contains '3' then
       elseif array contains '2' then
       ...
  </code></pre>