Results 1 to 3 of 3

Thread: Oracle Help

  1. #1
    Join Date
    Jan 2003
    Posts
    41

    Unanswered: Oracle Help

    Hi

    before starting this, my oracle version is oracle 7.3 / Unix

    I need a solution for the following problem

    1) If any column inserted in oracle table, i need to generate a xml file
    without using trigger, is there any other solution?

    2)suppose if i am allowed to create a trigger, is it possible to create the xml in network directory (windows and unix)

    3) Suppose if i have oracle 9i, how can i acheive this?

    Thanks
    JT

  2. #2
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Oracle Help

    Originally posted by jtamil2001
    Hi

    before starting this, my oracle version is oracle 7.3 / Unix

    I need a solution for the following problem

    1) If any column inserted in oracle table, i need to generate a xml file
    without using trigger, is there any other solution?

    2)suppose if i am allowed to create a trigger, is it possible to create the xml in network directory (windows and unix)

    3) Suppose if i have oracle 9i, how can i acheive this?

    Thanks
    JT
    1) If any column inserted in oracle table, i need to generate a xml file
    without using trigger, is there any other solution?

    r.- I think is quite difficult to do somethink like that in that version.

    2)suppose if i am allowed to create a trigger, is it possible to create the xml in network directory (windows and unix)

    r.- Yes, using UTL_FILE package

    3) Suppose if i have oracle 9i, how can i acheive this?

    r.- In 9i there are XML Datatypes and you can create external files with UTL_FILE package

    UTL_FILE
    With the UTL_FILE package, your PL/SQL programs can read and write operating system text files. UTL_FILE provides a restricted version of operating system stream file I/O.

    UTL_FILE I/O capabilities are similar to standard operating system stream file I/O (OPEN, GET, PUT, CLOSE) capabilities, but with some limitations. For example, you call the FOPEN function to return a file handle, which you use in subsequent calls to GET_LINE or PUT to perform stream I/O to a file. When file I/O is done, you call FCLOSE to complete any output and free resources associated with the file.

    http://download-west.oracle.com/docs...e.htm#ARPLS069
    Joel Pérez

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    You can create an XML file in 7.3. The issue is that you have to do all the work your self. Using the UTL_FILE package you can create a file however you wish. If you can get 9i your life is much simpler because as has been said 9i is aware of XML.

Posting Permissions

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