+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Error using Cx_Oracle (/thread-25877.html)
Error using Cx_Oracle - naya - Apr-14-2020
Hello,
I am kinda new to python and i need help with my code.
I am trying to use cx_Oracle to insert my data from a flat file into my oracle database table (oracle 12c).
After reading my data using pandas and looping over it, I get the error " DatabaseError: ORA-01008: not all variables bound" when trying to insert.
I need urgent help resolving this.
Here is the portion of my code having the error:
for key, value in indvdl.sample(4 , replace=True).iterrows():
print (type( value))
for x in value.to_dict().items():
sql = """INSERT INTO individuals (CUSTOMER_ID, BRANCH_CODE, Surname, FIRST_NAME, MIDDLE_NAME, Date_of_Birth, National_Identity_Number, Drivers_License_No, BVN, Passport, Gender, Nationality, Marital_Status, Mobile_number, Primary_Address_Line_1, Primary_Address_Line2, Primary_city, Primary_State, Primary_Country, Employment_Status, Occupation, Business_Category, Business_Sector, Borrower_Type, Other_ID, Tax_ID, Picture_File_Path, Email, Employer_Name, Employer_Address_Line1, Employer_Address_Line2, Employer_City, Employer_State, Employer_Country, Title, Place_of_Birth, Work_phone, Home_phone, Sec_Address_Line1, Sec_Address_Line2, Sec_Address_City, Sec_Address_State, Sec_Address_Country, Spouses_Surname, Spouses_firstname, Spouses_Middlename, CYCLE_VER, DPID)
VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48)"""
cursor.execute(sql, tuple(x))
RE: Error using Cx_Oracle - ndc85430 - Apr-17-2020
Have you checked that there are as many items in
x as are expected in the query?
RE: Error using Cx_Oracle - ibreeden - Apr-17-2020
And also: "cursor.execute()" should be indented just as "sql = ...".