sorry, ne taip gal suformulavau klausima declare lxt_xml xmltype; begin lxt_xmltype:= tmltype('<foo>abc</foo>'); /* vat dabar i lxt_xmltype reikia dadeti atributa ta prasme, kad i jau egzistuojanti xmlelement'a arba klausimas is auksciau: kaip perduoti xmlelement'o name'a "foo" per kintamaji */ end; "rl" <ask@me.for> wrote in message news:haulqs$ur4$1@trimpas.omnitel.net... > SELECT xmltype('<?xml version="1.0" encoding="UTF-8"?>' || chr(10) || > xmlelement("foo", > xmlattributes('atr1value' AS "atr1"), > 'abc') > ) from dual > > rr wrote: >> beja gal kas zino kaip turint >> >> xmlelement'a tiesiog prideti jam attribute'a? >> na pvz turiu XMLType(<foo>abc</foo>) kaip jam dadeti atributa >> atr1="atr1value"? >> >> >> >> "rr" <me@you.us> wrote in message >> news:haufn6$khs$1@trimpas.omnitel.net... >>> Sveiki, >>> >>> gal kas gali padeti tokioje situacijoje >>> >>> turiu 3 kintamuosius nodeName, attrValue, nodeValue >>> kaip gauti <nodeName bilekas="attrValue">nodeValue</nodeName> ?? >>> nenoriu naudoti dbms_'u >>> >>> problema, kad XMLElement reikia nurodyti name'a kaip konstanta (o gal >>> klystu)? >>> t.y. XMLElement(nodeName, XMLAttributes( attrValue as "bilekas"), >>> nodeValue) nepraina, gal ko nzn? >>> >>> bandziau: >>> SYS_XMLGEN(nodeValue, XMLFormat(nodeName)) bet nzn kaip ideti attributa? >>> >>> is anksto aciu >>> >>