You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cocoon.apache.org by Lionel Crine <cr...@4dconcept.fr> on 2005/07/28 19:44:10 UTC

xmltype and sql transformer

I'm trying to get an XMLTYPE from oracle.

Here is the query :
<sql:query name="name">SELECT ir_struct FROM T_BNF_IR WHERE ir_sysID 
='32'</sql:query>
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 :
<ir_struct||><blabla>....</blabla><it_struct||>


What can I do ?

Lionel



-- 
Lionel CRINE
Ingénieur Systèmes documentaires
Société : 4DConcept
22 rue Etienne de Jouy 78353 JOUY EN JOSAS
Tel : 01.34.58.70.70 Fax : 01.39.46.06.90

Re: xmltype and sql transformer

Posted by lionel crine <cr...@4dconcept.fr>.

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 :
> <sql:query name="name">SELECT ir_struct FROM T_BNF_IR WHERE ir_sysID 
> ='32'</sql:query>
> 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 :
> <ir_struct||><blabla>....</blabla><it_struct||>
> 
> What can I do ?
> 
> Lionel
> 
> -- 
> Lionel CRINE
> Ingénieur Systèmes documentaires
> Société : 4DConcept
> 22 rue Etienne de Jouy 78353 JOUY EN JOSAS
> Tel : 01.34.58.70.70 Fax : 01.39.46.06.90


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org