Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate Excel report from Forms; convert char to number

549494Dec 1 2006 — edited Dec 7 2006

Hello,
I am using TEXT_IO to generate Excel report in Forms 6i. Everything is fine except one little problem. One of the fields in the query is f.g. Version (VARCHAR2) which looks like, 2.0 or 3.0 in the form. When Excel spreadsheet is generated it converts this value and displays this column as 2 or 3. Is there way to maintain the format and still display it as 2.0 and 3.0? I'm passing it as: text_io.put(file_id, Nvl(p_item_value,' '));

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2007

Added on Dec 1 2006

#forms, #moved-from-devops

6 comments

1,451 views