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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]