title: Load table to Oracle through pandas io SQL
body: <p>Im executing the following code, the purposes of the exeuction is to create a lookup-table in the Oracle data base to speed up my load of data. The table I want to load in is simply a vector with ID values, so only one column is loaded.</p>
  
  <p>The code is written per below:</p>
  
  <pre><code>lookup = df.id_variable.drop_duplicates()
  
  conn = my_oracle_connection()
  obj = lookup.to_sql(name = 'lookup', con = conn, if_exists = 'replace')
  </code></pre>
  
  <p>I get the following error when exeucting this:</p>
  
  <blockquote>
    <p>DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master
    WHERE type='table' AND name=?;': ORA-01036: illegal variable
    name/number</p>
  </blockquote>
  
  <p>I can execute a psql.read_sql() query but above fails.</p>
  
  <p>Now, I dont exactly know how to go about fixing it, im quite new to the technical aspects of getting this to work so any pointers in what direction to take it would be greately appriciated.</p>
  
  <p>Thanks for any time and input! </p>