Databases
StackOverflow2013
Postsdbo
POHow can I save PL/SQL output (clob) as an XML file?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I save PL/SQL output (clob) as an XML file?
    primarykey
    data
    text
    <p>I feel quite stupid at this stage as this doesn't seem like a task i should be battling with, but after little sleep and with a 1000 thoughts running through my mind I think i'm the frog in the pot now with the tunnel-vision-virus clouding the solution. Here goes:</p> <p>I have a query in PL/SQL that selects data out of a few tables into an XML format (1 row, 1 column being a CLOB type) using DBMS_XMLGEN.getxml. This works perfectly.</p> <p>My problem comes in returning this XML output to C#, and asking the user where he'd like to save this output as an output.xml file, on his personal pc.</p> <p>I'm using ASP.net with JQuery (AJAX), thus posting to an .aspx page when a link is clicked and using the returned data (the xml coming from the query in this instance) to save. Using an OLEDB command with an OLEDB datareader doesn't seem to be the correct way...</p> <p>What is the best way of doing this? I haven't worked a lot with serialization within .net, but i assume this is the best way (according to the research I've done)? Does anyone have an example of how this can be done in my situation? </p> <p>My thoughts are basically creating this output / file in memory, asking the user where he wants to save it, saving it as a .xml file and clearing the memory.</p> <p>UPDATE: Ok I managed to create an XMLDocument which easily just accepts the xml output from my query. How could I go about getting input from the user on where to save this file on his pc?</p> <p>My code so far:</p> <p>Javascript : </p> <pre><code>function XML_ExportAppRestrictions() { try { var data = {"action": "exportAppRestrictions"}; var returned = AjaxLoad('Modules/Common/Common.aspx', null, data, null, null, false); if (returned.toString().toUpperCase().substring(0, 5) == "ERROR") { return; } else { // should the file be saved here or in my aspx page using xmldoc.save? // Using xmldoc.save will only be able to save the file on the server yes? } } catch (ex) { alert(ex.Message); } } </code></pre> <p>ASP:</p> <pre><code>if (Request["action"] == "exportAppRestrictions") { // Create and open DB connection conn.ConnectionString = SG_Common.CommonClass.NetRegUDL; common.OpenDBConnection(ref conn); // Create command and set SQL statement cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.Text; // select text was removed below due to it's length cmd.CommandText = "select x as AppRestrictions from dual"; rd = cmd.ExecuteReader(); if (rd.HasRows) { if (rd.Read()) { str = rd["AppRestrictions"].ToString(); } } rd.Close(); System.Xml.XmlDocument xmldoc = new System.Xml.XmlDocument(); xmldoc.InnerXml = str; xmldoc.Save("c:\\xmltest.xml"); goto Done; } // Done runs in a seperate try/catch statement and only returns data to the calling js function. Done: Response.Write(str); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKDT
    1. USKDT
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I save PL/SQL output (clob) as an XML file?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow can I save PL/SQL output (clob) as an XML file?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow can I save PL/SQL output (clob) as an XML file?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMy answer's Update 1 was erroneously for Windows SaveFileDialog. Update 2 shows code for a Web Response with content disposition.
      singulars
      1. POHow can I save PL/SQL output (clob) as an XML file?
      1. UScriticalfix
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload