Re: [cx-oracle-users] SQLX support ?

[Anthony T. <an...@co...>]

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