title: ORA-01747: invalid user.table.column, table.column, or column specification
body: <p>Get the above error when the execute immediate is called in a loop</p>
  
  <pre><code>Update CustomersPriceGroups set  1AO00=:disc  Where cuno=:cuno
      Parameters:   disc=66 cuno=000974
  Update CustomersPriceGroups set  1AP00=:disc  Where cuno=:cuno
      Parameters:   disc=70.5 cuno=000974
  Update CustomersPriceGroups set  1AQ00=:disc  Where cuno=:cuno
      Parameters:   disc=66 cuno=000974
  Update CustomersPriceGroups set  1ZA00=:disc  Where cuno=:cuno
      Parameters:   disc=60 cuno=000974
  </code></pre>
  
  <p>What does this mean ?</p>
  
  <p>Here is the code fragment</p>
  
  <pre><code>    c:=PriceWorx.frcPriceListCustomers('020','221');
  LOOP
    fetch c into comno,cuno,nama,cpls;
    exit when c%notfound;
    dbms_output.put_Line(cuno);
     g:=priceWorx.frcPriceListItemGroups('020','221');
     d:=priceworx.frcCustomerDiscounts('020','221',cuno);
    loop
      fetch g into comno,cpgs,n;
      fetch d into comno,cpls,cuno,cpgs,stdt,tdat,qanp,disc,src;
      --dbms_output.put(chr(9)||cpgs);
      sQ:='Update saap.CustomersPriceGroups set "'|| trim(cpgs)||'"=:disc '
         || ' Where cuno=:cuno';
      execute immediate sQ using disc,cuno; 
      commit;
      dbms_output.put_line( sQ );
      dbms_output.put_line( chr(9)||'Parameters:   disc='|| disc||' cuno='||cuno);
      exit when g%notfound;
    end loop;
    close g;
    close d;
  end loop;
  </code></pre>