Cursors in a Loop
carsten at uniqsys.com
Fri Jan 4 15:32:27 CET 2008
On Fri, 2008-01-04 at 00:03 -0800, Chris wrote:
> You should bind all variables to save the pool.
> cursor = connection.cursor()
> cursor.executemany("""insert into as_siebel_hosts_temp
> values (:whole, :lot, :of, :bind, :variables)
> ,[(i,) for i in hostlist]
Huh? In the OP's example, the table one has one column. I'll openly
admit that I don't know anything about Oracle, but that code doesn't
make sense to me. Maybe you're trying to execute a multi-row insert, but
that would be done with execute(), not executemany(), wouldn't it?
Also, isn't "[(i,) for i in hostlist]" exactly the same as "[i for i
in hostlist]" which in turn is exactly the same as "hostlist"?
More information about the Python-list