Re: a cx_Oracle ORA-01036 problem

2005-05-12 Thread Damjan
>> 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)""" >> > Try using a variable name other than "id" for the CARDREF variable... say > "card_id".

Re: a cx_Oracle ORA-01036 problem

2005-05-06 Thread Miles
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_DEADL

Re: a cx_Oracle ORA-01036 problem

2005-05-05 Thread Damjan
vincent wehren wrote: > |c = db.cursor() > |c.execute(SQL, **args) > > > Shouldn't that be c.execute(SQL, args) (no **-unpacking of the > dictionary)? Actually I tried that too, I still get the same error. -- damjan -- http://mail.python.org/mailman/listinfo/python-list

Re: a cx_Oracle ORA-01036 problem

2005-05-05 Thread vincent wehren
"Damjan" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] | 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

a cx_Oracle ORA-01036 problem

2005-05-05 Thread Damjan
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)"