Re: [cx-oracle-users] INSERT examples

[Robert <web...@gm...>]

How to make below code work ?
curs1 has 8 columns, I want to insert into table with 9 columns - 'FOO' in col_9


> for row in curs1:
>     curs2.execute('insert into emp2(empno,ename,job,mgr,hiredate,sal,comm,deptno, col_9) values (:1,:2,:3,:4,:5,:6,:7,:8)',row, 'FOO')
>

TypeError: function takes at most 2 arguments (3 given)