[cx-oracle-users] Retrieving XLMType from Oracle
Brought to you by:
atuining
|
From: Carl B. <cbi...@nr...> - 2005-04-15 14:23:56
|
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...
|