title: How to assign variables using dynamic sql
body: <p>I need to assign two variables(tmp_x and tmp_y) with dynamic sql, because I need to select the right table at runtime. the sql as below:</p>
  
  <pre><code> updateSql:= 'select p.gis_x,p.gis_y into tmp_x,tmp_y from  publish_'
               ||splitCollection(indexs).city_no ||'.t_customer p 
               where p.customer_id=:1 and p.gis_x is not null and p.gis_y is not null';
  
   execute immediate updateSql using splitCollection(indexs).CUSTOMER_ID;
  </code></pre>
  
  <p>the compilation is OK ,but occur the runtime error about "lack of keyword",  how can I fix that?</p>