MS word file in Oracle

[tandonpiyush]

How can i keep MS word file in one of the field of Oracle 10g database.

And i want to access, display the same file trough my jsp servlet application.

Can any1 help!!

[Tolls]

Store it as a BLOB.
Use the setBinaryStream() method on a PreparedStatement to send the file stream to the db.
Use the getBS() to retrieve it and send to the front end (with the correct response header).

[tandonpiyush]

Kindly help me creating one application for uploading and downloading word or pdf files in /from database(oracle)

[Tolls]

I've given you the pointers.
I'm not going to write it for you.
If you have a problem when you write your code then ask and we'll try and solve the issue.

[tandonpiyush]

wat will be the query for storing pdf or word file in oracle.I have created the following table:

Column Name Data Type Nullable Default Primary Key
DOCNAME VARCHAR2(15) Yes - -
DOCTYPE VARCHAR2(10) Yes - -
DOCID VARCHAR2(15) Yes - -
DOC BLOB Yes - -


But when i insert any row it shows the following:


Table: DOCDETAILS
Docname
Doctype
Docid
Doc not available to insert data

[Tolls]

Show us the code that's trying to insert the data, and also the full exception (plus stacktrace) of the problem you're getting.