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