Download a file from the server using Java Servlet

[Bhasker Reddy]

I am executing a Stored PRocedure by passing the parameters
using JDBC and Java Servlets. After the execution, the stored procedure generates a data and that data is stored on oracle on unix. I want the ability to download that data(or file) onto
my local machine(user's local machine).
Do anyone has any code that does that or any ideas.
thanks

[Jamie Robertson]

what is the Oracle column type that you are trying to retrieve?

[Bhasker Reddy]

it's a file, like export.out, i need to get that file onto my
local machine from the oracle on unix box.

[Jamie Robertson]

you said "and that data is stored on oracle on unix. I want the ability to download that data(or file)." I assume that you have already written to a database and you just want to extract the file that you've stored. I don't know of any file datatype. The only oracle data types that I know of are CHAR, NCHAR, VARCHAR2, NVARCHAR2, NUMBER, DATE, RAW, BLOB, CLOB, NCLOB, BFILE, LONG, LONGRAW and ROWID...but no file type. I'll assume BLOB/CLOB? you can find source code put out by oracle at http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/content.html . Look for the "JDBC Advanced Features Samples" link.

Jamie
[This message has been edited by Jamie Robertson (edited September 24, 2001).]

[Bhasker Reddy]

you got me wrong. I don't want to extract the file. I want the
file to download onto my local machine IN OTHER WORDS I WANT IT
FTP THE FILE FROM ORACLE/UNIX TO MY LOCAL MACHINE.
i WANT TO HAVE A BUTTON, WHICH WHEN CLICKED SHOULD BE ABLE TO
POP UP A DIALOG BOX ASKING TO SPECIFY THE DIRECTORY ON THE LOCAL MACHINE TO SAVE THE FILE.
THE FILE