Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2011
    Posts
    7

    Unanswered: Export to Excel via oracle storedprocedure

    Hi

    I need to export my query results from my oracle stroredprocedure to an excel sheet. Could you please send me an example of how it is done.

    Thanks and regards,
    Ranjit Menon

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Install Oracle client software on Windows system running Excel.
    Then connect Excel to Oracle DB via ODBC protocol & issue SQL directly from Excel against the DB
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2011
    Posts
    7
    I am using oracle toad to develop the storeprocedure. DBMS scheduler would execute this storeprodure and the storeprocedure needs to query the database and export the results to excel.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle does not support "native" Excel file format.
    Your procedure must produce file either in Comma Separate Value or XML format;
    both of which Excel understands
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2011
    Posts
    7
    Do you have a sample code of how it is done

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Sep 2011
    Posts
    7
    Thanks .Do let me know if you have found anything.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Do let me know if you have found anything.

    I am sorry to see that GOOGLE is broken for you.
    Please be patient while repairs are completed.
    Additional information will be posted when it becomes available.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    you can also write an excel file using oracle forms and OLE or one of the number of packages that will create the file Apache POA, ORA_EXCEL (www.oraexcel.com)...
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  10. #10
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253

  11. #11
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253

    Post

    So, I have received this question so many times recently, I created a post for it.
    See: Simplest example of writing to MS Excel using an Oracle Stored Procedure
    Hope this helps.

Posting Permissions

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