Passing python list oracle where clause cx_Oracle
<p>I'm frustrated trying to pass a Python list to an Oracle WHERE clause. I'm using cx_Oracle, here's my code:</p>

<pre><code># -*- coding: utf-8 -*-
from __future__ import unicode_literals
import cx_Oracle

con = cx_Oracle.connect(str('user/passwordr@server/orcl'))
cursor = con.cursor()
ids = [19 , 87 , 84]
cursor.execute(str("select  employee_id , first_name , last_name from employees  where employee_id in ('"+ids+"')" ))
people = cursor.fetchall()
print people

'''The following code works for me , but the problem is the string formater placeholer is not gonna be static is dynamic.'''
params = (198 , 199)
cursor.execute(str("select  employee_id , first_name , last_name from employees  where employee_id in ('%s' , '%s')" %(params)))

'''Also it would be valid if i can create dynamically the string formater placeholder depending on "length of something".
Sorry if this question was answered i spend hours searching the solution , but i do not found it.'''
</code></pre>