By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,706 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,706 IT Pros & Developers. It's quick & easy.

Problem in wirting data in Excel sheet using owa_util package

P: 3
Hi ALL,

I written code to download data in Excel from webpage in PLSQL.
i have used owa_util.mime_header 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
Mar 26 '08 #1
Share this Question
Share on Google+
2 Replies


Saii
Expert 100+
P: 145
What is the datatype for the column in db table( number or varchar)?

Hi ALL,

I written code to download data in Excel from webpage in PLSQL.
i have used owa_util.mime_header 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
Mar 26 '08 #2

P: 3
What is the datatype for the column in db table( number or varchar)?
datatype is of VARCHAR2

i used function to_char(job_number) before writing to Excel but it didnt workout.
Apr 2 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.