I spoke too fast,
I used to make it work : SELECT ir_struct||'' AS ir_struct ...
Lionel
On Thu, 28 Jul 2005 19:44:10 +0200, Lionel Crine wrote
> I'm trying to get an XMLTYPE from oracle.
>
> Here is the query :
> SELECT ir_struct FROM T_BNF_IR WHERE ir_sysID
> ='32'
> but it returns nothing
I'm trying to get an XMLTYPE from oracle.
Here is the query :
SELECT ir_struct FROM T_BNF_IR WHERE ir_sysID
='32'
but it returns nothing.
I have to write :SELECT ir_struct||'' instead of SELECT ir_struct
But this generates xml error because : the resut send :
What can I do ?
Lionel
