a cx_Oracle ORA-01036 problem

[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(:INVOIC E_DATE,'DD.MM.Y Y'),
to_date(:PAYMEN T_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_e ur, DEBTDEN=iznos_m kd, INVOICE_DATE=da tum_g,
PAYMENT_DEADLIN E=datum_d, POINTS=bodovi)

And I get an ORA-01036 exception.

I also have tried
args = dict(CARDREF=id , BANKKEY=dc_kluc , OK1=okd, OK2=okc,
DEBTEUR=iznos_e ur, DEBTDEN=iznos_m kd, INVOICE_DATE=da tum_g,
PAYMENT_DEADLIN E=datum_d, POINTS=bodovi)
c = db.cursor()
c.execute(SQL, **args)
Same thing.

Everything works If I use python string substituion, like this sql:
SQL = """insert into D.D_NOTIFY values (%s,'%s','%s',' %s','%s','%s', \
to_date('%s','D D.MM.YY'),to_da te('%s','DD.MM. YY'),'%s')""" % fields

Any ideas?
--
damjan

[vincent wehren]

"Damjan" <gd*****@gmail. com> schrieb im Newsbeitrag
news:42******** @x-privat.org...
| 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(:INVOIC E_DATE,'DD.MM.Y Y'),
| to_date(:PAYMEN T_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_e ur, DEBTDEN=iznos_m kd, INVOICE_DATE=da tum_g,
| PAYMENT_DEADLIN E=datum_d, POINTS=bodovi)

| And I get an ORA-01036 exception.
|
| I also have tried
| args = dict(CARDREF=id , BANKKEY=dc_kluc , OK1=okd, OK2=okc,
| DEBTEUR=iznos_e ur, DEBTDEN=iznos_m kd, INVOICE_DATE=da tum_g,
| PAYMENT_DEADLIN E=datum_d, POINTS=bodovi)
| c = db.cursor()
| c.execute(SQL, **args)
Shouldn't that be c.execute(SQL, args) (no **-unpacking of the dictionary)?

--

Vincent Wehren
| Same thing.
|
| Everything works If I use python string substituion, like this sql:
| SQL = """insert into D.D_NOTIFY values (%s,'%s','%s',' %s','%s','%s', \
| to_date('%s','D D.MM.YY'),to_da te('%s','DD.MM. YY'),'%s')""" % fields
|
| Any ideas?
|
|
| --
| damjan

[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

[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(:INVOIC E_DATE,'DD.MM.Y Y'),
to_date(:PAYMEN T_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_e ur, DEBTDEN=iznos_m kd, INVOICE_DATE=da tum_g,
PAYMENT_DEADLIN E=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

[Damjan]

>> SQL = """insert into D.D_NOTIFY values (:CARDREF, :BANKKEY, :OK1, :OK2 \

:DEBTEUR, :DEBTDEN, to_date(:INVOIC E_DATE,'DD.MM.Y Y'),
to_date(:PAYMEN T_DEADLINE,'DD. MM.YY'), :POINTS)"""

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...

I changed it to 'cardref' but I'm still getting the same error.
--
damjan