title: Oracle xmlexists in pl/sql block
body: <p>in a regular query I can use the <code>xmlexists</code> function to look if a specific value is present in a <code>xmltype</code> column. But when I want to use it in a pl/sql block the script will not compile because of a syntax error (encountered the symbol "passing" when expecting one of the following...).</p>
  
  <p>Simple script example:</p>
  
  <pre><code>DECLARE
    v_xml xmltype;
  BEGIN
    for rec in (select xmltypecol from mytable where type='XXX')
    loop
      v_xml := rec.xmltypecol;
      if xmlexists('/test[node=(10,12)]' passing v_xml) then
        -- processing 
      end if;                                                          
    end loop;
  END;
  </code></pre>
  
  <p>What is the right way to use <code>xmlexists</code> in a pl/sql block ?</p>
  
  <p>Thanks!</p>