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
begin:vcard
fn:Lionel Crine
n:Crine;Lionel
adr:;;22 rue Etienne de Jouy;JOUY EN JOSAS;;78353;FRANCE
email;internet:[EMAIL PROTECTED]
title:documentary systems engineer
tel;work:01.34.58.70.70
tel;fax:01.39.46.06.90
x-mozilla-html:FALSE
url:http://www.4dconcept.fr
version:2.1
end:vcard
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
