'DPI-1044: value cannot be represented as an Oracle number

I was using the below code for more than a month and it suddenly throws an error and i have no idea what went wrong. The number of records in equity_redemption.csv keeps getting updated every week. As of now there are 3 million records.

        try:
            data_equity = pd.read_csv(r"RedmptionDebt_op/equity_redemption.csv")
            try :
                self.cur.execute('Drop table eq_fnl')
            except:
                print('No such Table Exist')
            finally:
                self.cur.execute('CREATE table eq_fnl(PAN_NO varchar(15),probability float, EQUITY_AUM float,HML varchar(15))')

            rows = [tuple(x) for x in data_equity.loc[:,['PAN_NO','probability','EQUITY_AUM',"HML"]].values]
            query=("""insert into eq_fnl(PAN_NO,probability,EQUITY_AUM,HML) values(:1,:2,:3,:4)""")
            self.cur.executemany(query,rows)

I was trying to implement the above code and i am getting an error in the below line:

rows = [tuple(x) for x in data_equity.loc[:,['PAN_NO','probability','EQUITY_AUM',"HML"]].values]
            query=("""insert into eq_fnl(PAN_NO,probability,EQUITY_AUM,HML) values(:1,:2,:3,:4)""")
            self.cur.executemany(query,rows)

This same code has worked for me for a different data. but it throws an error only for one of the file.

equity_redemption.csv looks like this:

EQUITY_AUM      PAN_NO      TOTAL_PURCHASE,   PROBABILITY,            HML
26329.00         XXXX           1000         0.0108140940397026       High
2719.45          yyyy           2637         2.7302823560174E-130     Low
771165.94125     zzzz           47383        1.66832572553501E-129    Medium

Can someone help me understand what could be the possible reason for this error --> DPI-1044: value cannot be represented as an Oracle number

pythonsqloracle


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions