[cx-oracle-users] Retrieving XLMType from Oracle

[Carl B. <cbi...@nr...>]

All,

I have been trying to retrieve xml data type from
an oracle database.  The server uses Oracle 10g and
I am using python 2.4.1, cx_Oracle 4.1, Oracle client for 10g
all on a windows XP machine (with sp 2).

The database has two fields a string and an xmltype. If I
retrieve with the SQL statment

select str from proposal

where specifying the string field only all works fine.

If I use

(a) select * from proposals

I recieve the error

NotSupportedError: Variable_TypeByOracleDataType: unhandled data type 108

(b) setinputsize(value=cx_Oracle.CLOB) with the same select statment
I recieve the error:

     cursor.execute( "select * from proposals" )
DatabaseError: ORA-01036: illegal variable name/number

Any suggestions?  Many thanks in advance.

Carl Bignell
cbi...@nr...