Damjan wrote: > I'm using Python 2.4, cx_Oracle-4.1 on Linux with Oracle instant client > 10.1.0.3. This is the sql string: > > SQL = """insert into D.D_NOTIFY values (:CARDREF, :BANKKEY, :OK1, :OK2 \ > :DEBTEUR, :DEBTDEN, to_date(:INVOICE_DATE,'DD.MM.YY'), > to_date(:PAYMENT_DEADLINE,'DD.MM.YY'), :POINTS)""" > > And I'm trying to execute it as: > c = db.cursor() > c.execute(SQL, CARDREF=id, BANKKEY=dc_kluc, OK1=okd, OK2=okc, > > DEBTEUR=iznos_eur, DEBTDEN=iznos_mkd, INVOICE_DATE=datum_g, > > PAYMENT_DEADLINE=datum_d, POINTS=bodovi) > > And I get an ORA-01036 exception.
Try using a variable name other than "id" for the CARDREF variable... say "card_id". id is a built in function name; I suspect your problem may be that you are assiging that function to the variable rather than your intended value... Miles -- http://mail.python.org/mailman/listinfo/python-list
