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
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).]
Joined: Jun 13, 2000
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