title: Oracle Execute Immediate throws missing keyword error
body: <p>In my stored procedure I use the following query:  </p>
  
  <pre><code>SELECT COUNT(*) INTO COL_NO FROM user_tab_columns WHERE table_name='PAY_SLIP_FEB_16';  
  </code></pre>
  
  <p>This query gives no error (because it shouldn't). But the table name here is fixed so I want to use a variable that will provide the table name. So I changed the query like this:  </p>
  
  <pre><code>EXECUTE IMMEDIATE 'SELECT COUNT(*) INTO COL_NO FROM user_tab_columns WHERE table_name='''||TBL_NAME||'''';  
  </code></pre>
  
  <p>This query gives error:  </p>
  
  <pre><code>ORA-00905: missing keyword  
  </code></pre>
  
  <p>What did I do wrong? TIA.  </p>
  
  <p>N.B. : TBL_NAME is the incoming parameter that will provide the table name, and COL_NAME is just a NUMBER(5,0) type variable.</p>