title: Oracle - Stored Procedure. Update Table, with Table name according to arguments
body: <p>So I have a Store Procedure for Updating a certain table with the name of the table is according to arguments <code>v_example</code> inputed.</p>
  
  <pre><code>PROCEDURE update_name(example_id NUMBER, v_example VARCHAR2, lcursor out rcursor)
  AS
  v_sequel VARCHAR2(10000);
  Begin
      UPDATE T_EXAMPLE_'||v_example||'_L1 SET T_EXAMPLE_'||v_example||'_L1.SUM1 = (SELECT T_SDEXAMP_'||v_example||'.SUM1
                                                          FROM T_SDEXAMP_'||v_example||'
                                                          WHERE T_SDEXAMP_'||v_example||'.BILATERAL_ID = T_EXAMPLE_'||v_example||'_L1.BILATERAL_ID),
                                T_EXAMPLE_'||v_example||'_L1.SUM2 = (SELECT T_SDEXAMP_'||v_example||'.SUM2
                                                          FROM T_SDEXAMP_'||v_example||'
                                                          WHERE T_SDEXAMP_'||v_example||'.BILATERAL_ID = T_EXAMPLE_'||v_example||'_L1.BILATERAL_ID),
                                T_EXAMPLE_'||v_example||'_L1.SUM3 = (SELECT T_SDEXAMP_'||v_example||'.SUM3
                                                          FROM T_SDEXAMP_'||v_example||'
                                                          WHERE T_SDEXAMP_'||v_example||'.BILATERAL_ID = T_EXAMPLE_'||v_example||'_L1.BILATERAL_ID)
      WHERE T_EXAMPLE_'||v_example||'_L1.BILATERAL_ID = '||example_id||';
      COMMIT;
  End;
  </code></pre>
  
  <p>So, as you can see, I want the table name to be a <strong>Combination</strong> of T_EXAMPLE_, the arguments v_example, and _L1...</p>
  
  <p>When I execute the above script, it gaves me this error: </p>
  
  <p><code>ERROR line 1076, col 18, ending_line 1076, ending_col 32, Found ''||v_example||'', Invalid identifier: '||v_example||'</code></p>
  
  <p>Can someone help me? Thanks....</p>