[cx-oracle-users] SQLX support ?
Brought to you by:
atuining
|
From: Roland S. <rsa...@ma...> - 2005-01-19 15:51:10
|
Hi,
=20
I'd like to use some SQLX function with cx_Oracle but it seems to be not
supported yet.
Here is a very small and simple test of SQLX Query (it's working with
SQLPlus)...
My configuration is Python2.3 / Oracle9i ...
=20
###########
# Connection
myDsn =3D cx_Oracle.makedsn(myHostname, myPort, myInstance)
myConnection =3D cx_Oracle.connect(myUser,myPassword,myDsn)
=20
# Query
cursor =3D myConnection.cursor()
sql =3D """SELECT XMLElement(\"Attributes\", DAT_VALEUR1) FROM
AC_V_DATA_ALL"""
# Results
cursor.execute(sql)
for line in cursor.fetchall():
print line
###########
=20
So, I got the following error message :
Traceback (most recent call last):
File "Test.py", line 22, in ?
cursor.execute(sql)
cx_Oracle.NotSupportedError: Variable_TypeByOracleDataType: unhandled =
data
type 108
=20
Does I make some mistakes ?
If not, does it planned to be supported in later versions of cx_Oracle ?
=20
Thanks a lot.
=20
Roland.
-------------------------------------------------------------------------=
---
----
Aerocity Data Management Team
Transiciel Technologies
www.transiciel.com <http://www.transiciel.com/>=20
-------------------------------------------------------------------------=
---
----
=20
|