No, you did not make a mistake. User defined types are not currently
supported by cx_Oracle but I do have plans to do that at some point --
hopefully soon but recently I've been rather busy so I wouldn't count on
anything in the next couple of months. In the meantime your best option
is to use PL/SQL in your executed statement and pass back to Python
scalar types.
Roland SAIKALI wrote:
> Hi,
>
> 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 ...
>
> ###########
> # Connection
> myDsn = cx_Oracle.makedsn(myHostname, myPort, myInstance)
> myConnection = cx_Oracle.connect(myUser,myPassword,myDsn)
>
> # Query
> cursor = myConnection.cursor()
> sql = """SELECT XMLElement(\"Attributes\", DAT_VALEUR1) FROM
> AC_V_DATA_ALL"""
> # Results
> cursor.execute(sql)
> for line in cursor.fetchall():
> print line
> ###########
>
> 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
>
> Does I make some mistakes ?
> If not, does it planned to be supported in later versions of cx_Oracle ?
>
> Thanks a lot.
>
>
> Roland.
>
> --------------------------------------------------------------------------------
>
> */Aerocity Data Management Team/*
>
> Transiciel Technologies
>
> www.transiciel.com <http://www.transiciel.com/>
>
> --------------------------------------------------------------------------------
>
|
