asked on 9/13/2010

Export an oracle table to csv on a jsp page

Either using Servlets or JSP, how would I make an HTML link on my jsp page that would allow the user to download a table inside of Oracle as a CSV?
Thanks.

Oracle Database Java EE JSP

Last Comment

indsupport

9/28/2010

Ravindran Gopinathan

9/13/2010

I do not know much about JSP. But your requirement can be met with an Oracle stored procedure. Check the below link for implementation of the stored procedure

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:88212348059

You can provide link to the generated CSV file in your HTML file. The stored procedure can be executed on batch everyday (oracle jobs maybe) or execute on-demand basis (like button press)

Hope this helps!

indsupport

9/13/2010

ASKER

Funny you should like to that post. I'm already using that stored procedure to export to a local file. I don't want to use the local file system, however. I want to have everything directed to stdout. Similar to how it is done using PHP with mysql:

http://snipplr.com/view/2234/export-mysql-query-results-to-csv/

ASKER CERTIFIED SOLUTION

mrcoffee365

9/14/2010

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

indsupport

9/28/2010

ASKER

Still researching, will let you know -