Results 1 to 3 of 3

Thread: xml probs

  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    14

    Unhappy Unanswered: xml probs

    Hi

    I create an xml as

    queryCtx dbms_xmlquery.ctxType;
    queryCtx := dbms_xmlquery.newContext('select c1 "c1",c2 "c2" from tab1 where condition=cond1');
    result := dbms_xmlquery.getXml(queryCtx);

    but i get the tag <?xml version = '1.0'?>
    How is it possible to generate the xml without this tag?

    Pls help


    Regds
    Manoj

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: xml probs

    Originally posted by manojkv
    Hi

    I create an xml as

    queryCtx dbms_xmlquery.ctxType;
    queryCtx := dbms_xmlquery.newContext('select c1 "c1",c2 "c2" from tab1 where condition=cond1');
    result := dbms_xmlquery.getXml(queryCtx);

    but i get the tag <?xml version = '1.0'?>
    How is it possible to generate the xml without this tag?

    Pls help


    Regds
    Manoj
    This tag is needed for "well formed" xml document. Check specification...
    Possible solution is replace this tag by empty string after generation.

  3. #3
    Join Date
    Nov 2003
    Location
    India
    Posts
    14

    Re: xml probs

    Hi,
    I just gave an example only.Infact i'm querying from 2 to 3 tables and forming the xml.but in the end i'm appending the CLOB as one CLOB.so when i create the xml each time it gets a header tag.so each time time i have to search & replace the header tag.Is there any better way to do this?


    Regds
    Manoj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •