Uploading a file onto Oracle

[mythologyrocks]

Hi,

As a part of my project work, I need to upload files onto the oracle tables. For example, let's say I have a table called 'Assignment' to which the students in a particular course can upload their assignment files. The fields in the table are,

Assignment number,Course number,Student Id,Assignment file.

Here the field 'Assignment file' is indeed a file. What data type do v have in Oracle that can support file uploads. Kindly help me along with a simple example of how to upload a file.

Thankz in advance.

Mythology does rock!!!

 

[sem]

You definitely need LOB datatype. Oracle supports CLOB for text information, BLOB for binaries and BFILE to link OS file without physical transition file content to database. What tool do you plan to use to create your program? Are the files on the same host as database?

Regards, Dima

http://seminihin.narod.ru

 

[mythologyrocks]

Hi,

I am actually using ASP to write onto the oracle table. First of all, how shud i be creating a table that has 'FILE' as its data type?

Say for example I want to create a table test with fields A,B and C with A and B being number(10) and C has to a FILE. (any type of file, say doc, pdf, ps, jpeg, uml,etc.).Whats the syntax to create such a table?

Regards,
Mythology rocks