Problem in wirting data in Excel sheet using owa_util package

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • umeshchitta
    New Member
    • Mar 2008
    • 3
    #1

    Problem in wirting data in Excel sheet using owa_util package

    Hi ALL,

    I written code to download data in Excel from webpage in PLSQL.
    i have used owa_util.mime_h eader to write data in excel.But if data cmng from db table is "32E104" then data in Excel appears as "3.2E+104" in exponential form..Can anybody help me out with this issue.


    Thanks
    Umesh
    Tags: None
    • Saii
      Recognized Expert New Member
      • Apr 2007
      • 145
      #2
      What is the datatype for the column in db table( number or varchar)?

      Originally posted by umeshchitta
      Hi ALL,

      I written code to download data in Excel from webpage in PLSQL.
      i have used owa_util.mime_h eader to write data in excel.But if data cmng from db table is "32E104" then data in Excel appears as "3.2E+104" in exponential form..Can anybody help me out with this issue.


      Thanks
      Umesh

        Comment

        • umeshchitta
          New Member
          • Mar 2008
          • 3
          #3
          Originally posted by Saii
          What is the datatype for the column in db table( number or varchar)?
          datatype is of VARCHAR2

          i used function to_char(job_num ber) before writing to Excel but it didnt workout.

            Comment

            Previous template Next
            Working...