<p>我试图定义一个值(id号)列表,并将它们传递给查询Oracle表的SQL。在</p>
<p>只要我只包含一个id,这个代码就可以工作</p>
<pre><code>named_params = {'ids':'123456548'}
query = """
select PEBEMPL_ECLS_CODE
from PEBEMPL
inner join SPRIDEN on spriden_pidm = pebempl_pidm
where SPRIDEN_CHANGE_IND is null
and SPRIDEN_ID in :ids
"""
df = pd.read_sql(query, connection, params=named_params)
</code></pre>
<p>传递一个id列表的正确语法是什么?在</p>
<p>例如,此代码不起作用:</p>
^{pr2}$
<p>返回错误:</p>
<pre><code>': ORA-01484: arrays can only be bound to PL/SQL statements
</code></pre>