[destiny1]

Hi ,
I am getting the following error while trying to make an insert into the database using the DB-API cx_Oracle in python 2.5.
Earlier when I used DCOracle2 as DB-API the insert statement I used was working fine. But when I shifted to the other DB_API due to some compatibility issues, I get the following error:

Error:

>>> dbconnect.dbinsert("filelist.txt")
connection to db
89 97
298 298

Traceback (most recent call last):
File "<pyshell#3>", line 1, in <module>
dbconnect.dbinsert("filelist.txt")
File "C:\Documents and Settings\harshu\Desktop\project\final_python\dbconnect.py", line 85, in dbinsert
Result_list[ResultListIndex +2])
TypeError: function takes at most 2 arguments (7 given)

Following is the syntax I am using:

cursor.execute("insert into tbl_query_detail(hash_value,file_name,package_name,QUERY_NUMBER,\
author_name,FULL_QUERY,BASE_QUERY_INDICATOR) values \
(A.NEXTVAL,:file_name,ackage_name,:QUERY_NUMBER,:author_name,:FULL_QUERY,:BASE_QUERY_INDICATOR )"\
,filename,Result_list[0],Result_list[ResultListIndex],\
'abc',Result_list[ResultListIndex + 1],\
Result_list[ResultListIndex +2])


Please suggest the correct syntax.

Regards,
Harshu