This discussion is archived
2 Replies Latest reply: Feb 7, 2013 6:44 AM by CraigB RSS

Oracle forms clarification needed?

989749 Newbie
Currently Being Moderated
hi folks,

please check this attachment.
http://www.2shared.com/photo/WXem4CLn/jtable.html

i want this grid data, export the data into microsoft excel sheet.

am using oracle forms 10g.
  • 1. Re: Oracle forms clarification needed?
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    I am going to assume this is not a picture of a Forms multi-record block and instead is a grid-table (e.g. jtable). I will further assume you obtained it from here:

    http://forms.pjc.bean.over-blog.com/article-1830062.html

    Since this is not a native Oracle Forms component, you should contact the creator of the bean for help.
  • 2. Re: Oracle forms clarification needed?
    CraigB Guru
    Currently Being Moderated
    Welcome to the Oracle Forums. Please take a few minutes to review the following:
    <ul>
    <li>Oracle Forums FAQ
    <li>Before posting on this forum please read
    <li>10 Commandments for the OTN Forums Member
    <li>How to ask questions the smart way
    </ul>
    Following these simple guidelines will ensure you have a positive experience in any forum; not just this one! ;-)
    Lets start with some of the basics. What is your Forms version, Client OS version; if web deployed, your browser and Java versions?

    Before you start coding you need to ask yourself a few questions first. The solution is dictated by your needs. Questions like the following should get you started:
    1. Does the data truly have to be in Excel format or will a Comma Seperated (.csv) file work?
    2. How much data is being exported (a couple of rows or hundreds of rows)?

    Typically, the TEXT_IO or WebUtil's CLIENT_TEXT_IO pacakages are used to write data from a Form to a file. Which one you use is dependent on where you want the file exported too. With Forms 9i and higher, the TEXT_IO pacakage will write your file to Application Server, with Forms 6 and lower, it writes the file to the Client. If your Forms application is web deployed and you need to write the file to the Client computer, you will need to use WebUtil's CLIENT_TEXT_IO package or write the file to the application server and then transfer the file to the client (also using WebUtil).

    Depending on how much data you are write will also impact which option you choose. If you are write and small number of rows (less than 100) then writing the file directly to the Client would be ok. If you are dealing with more than 100 rows, I recommend you write the file to the Database or Application Server and then transfer the file to the client as writing data from a Form to a client file will be very very slow with larger data sets.

    For information on using either TEXT_IO or CLIENT_TEXT_IO, please search the Forms Help System for either package name.

    Hope this helps.
    Craig...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points