title: Insert Python variable into Oracle Database
body: <p>I can successfully insert an entire DataFrame into my Oracle table, but I cannot figure out how to insert a single variable into my it. I've failed using both bind variables and regular Python variables. </p>
  
  <p>My variable <code>year</code> prints out <code>2014</code>, in this case, because my code parses the year out of the document I run it on; and it'll eventually have to be run on 100's of documents. </p>
  
  <p>So my SQL statements are as follows:</p>
  
  <pre><code>cursor = con.cursor()
  exported_data = [tuple(x) for x in df_Quota.values]
  new_variable = year
  sql_query = ("INSERT INTO ROUGHTABLE(species, date_posted, stock_id, pounds, money, sector_name, ask)" "VALUES (:1, :2, :3, :4, :5, 'NEFS 2', '1')")
  year_command = ("INSERT INTO ROUGHTABLE(trade_year)" "VALUES (:1)")
  cursor.executemany(sql_query, exported_data)
  cursor.executemany(year_command, new_variable)
  con.commit() 
  
  cursor.close()
  con.close()
  </code></pre>
  
  <p>and that fails with the error <code>cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number</code>... It also fails when I simply try:</p>
  
  <pre><code>year_command = ("INSERT INTO ROUGHTABLE(trade_year)" "VALUES (year)")
  cursor.execute(year_command)
  </code></pre>
  
  <p>with the error <code>cx_Oracle.DatabaseError: ORA-00984: column not allowed here</code>...</p>
  
  <p>So I am very confused as to how to get a single Python variable into my Oracle table. Ideally I would like for the value of my variable <code>year</code> to export to the column <code>trade_year</code> in my Oracle table. Any help solving this would be greatly appreciated. </p>
  
  <pre><code>df_Quota:
  
     AvailableQuota DatePosted    ID LiveWeightPounds   price
  0         GOM COD       5/20  1724             2328  $9,000
  1        GOM HADD       5/20  1724              445  $9,000
  2          GOM BB       5/20  1724             3007  $9,000
  3        GREYSOLE       5/20  1724              850  $9,000
  4            DABS       5/20  1724             3101  $9,000
  5          GOM YT       5/20  1724             1995  $9,000
  6         GBE COD       5/20  1578              538   $1.00
  7           GB BB       5/20  1578             1755   $0.20
  8           GB YT       5/20  1578              243   $1.00
  9          SNE BB       5/20  1578              490   $0.45
  10         SNE YT       5/20  1578              153   $0.50
  11         GOM BB       5/20  1578             3965   $0.15
  12          Whake       5/20  1578             2727   $0.20
  13           POLL       5/20  1578             9227   $0.01
  14            RED       5/20  1578            15060   $0.01
  15        GBE COD       5/20   310              825  15,000
  16        GBW COD       5/20   310             9033  15,000
  17           DABS       5/20   310            12419  15,000
  18          WHAKE       5/20   310             3120  15,000
  19           POLL       5/20   310            65234  15,000
  20            RED       5/20   310            76610  15,000
  21         SNE BB       5/20   310             2121  15,000
  22         GOM BB       5/20   310             7285  15,000
  </code></pre>