title: How to pass multiple values as single parameter in Oracle SQL
body: <p>I am trying to update values in multiple schemas which have the same table name.</p>
  
  <p>So i tried to create query to pass multiple values as single parameter but its not working. Kindly suggest me.</p>
  
  <pre><code>DECLARE
      v_sql varchar2(500);
      v_schema varchar(30);
      v_prj_id varchar2(4000);
      in_PRJ_ID varchar2(4000);
      v_prj_id := 'B00781728,B00781628,B00781611,A43670001';
  
      CURSOR c1 is
        SELECT v_prj_id from DUAL;
  
  BEGIN
  
      OPEN c1;
  
      FOR i IN (SELECT trim(regexp_substr(v_prj_id, '[^,]+', 1, LEVEL)) l FROM dual CONNECT BY LEVEL &lt;= regexp_count(v_prj_id, ',') + 1 ) LOOP
  
          FETCH c1 INTO in_PRJ_ID;
  
          EXIT WHEN c1%NOTFOUND;
  
          v_sql := 'UPDATE ' || in_PRJ_ID || '.SI_Recipient set email = email ||'';Seshadri.K@iconplc.com'''  ;
  
          EXECUTE IMMEDIATE v_sql;
  
      END LOOP;
  
      CLOSE c1;
  
  END;
  </code></pre>