Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Unanswered: XML Generation question

    Hi to all...

    Since I'm new to this forum, sorry if something like that already exists as a topic.

    Anyway, my question has to do with XML files generation through Oracle (10g or 11g).

    I have a specific client, who now uses SQL SERVER 2005 and for some reasons the need for migration into Oracle has been decided. The customer has some jobs in SQLSRV which generate XML files using sp_createwebtask (passing an xml template file - not xsd file), and sp_runwebtask procedures for the creation of XML files with data from the SQLSRV.

    I was wondering if there is something in Oracle like those two SQLSRV procedures (sp_createwebtask, sp_runwebtask).

    Thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    I have no idea what those SQL Server functions are doing, but check out the XML functions of Oracle:

  3. #3
    Join Date
    Jun 2009
    Thanks for your reply...

    In general sp_createwebtask in SQLSRV as I found out, creates a web task using a template file (and anything that has to do with HTML and/or XML), and then sp_runwebtask creates XML/HTML files with the use of a stored procedure.

    If for example you create a procedure Prc1 that does

    select * from table1

    and then execute sp_runwebtask Prc1
    this will create a file with the results of the select statement.

Posting Permissions

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