URGENT How to export with PL/SQL, data from Oracle tables into DBF files
Posted on 2006-06-16
I have the following problem:
I want to export, through PL/SQL, data from a Oracle table directly to a DBF file.
I think that is beeing done with UTL_FILE function, but i don't know how to write the DBF file header.
I want that export to happen at the user request from a form.
The file then will be e-mailed or put on a CD.
Another question: UTL_FILE put the file on the server (i'm using Oracle Database 9.2 and 9iAS 9.2). How to transfer automatically the file to the user's HDD?
2 questions, both hard, i think.
Please help if u have any informations, links, etc.