Hello. I have a requirement from a customer(and a Web programmer) that from a Web page that a supporting (can be a large Pdf or Word file) document is be inserted into the database as a Blob.
Our environment here is a Windows NT client, an Windows NT Web Server using Asp, and a 8.1.5 database located on a UNIX platform.
My question is, since I have not done anything like this, what is the simple approach needed to upload that document into the database? I would like to used a stored procedure if possible. Can I upload directly from the client having the asp feed the document into the stored procedure? Must I use a third party solution? Or is the only approach is to copy the file to the database server and use a DBMS_Lob package from a directory recognized by Oracle (via a CREATE DIRECTORY command). I am looking for simple, but any advise would be appreciated. Thank you.
Our environment here is a Windows NT client, an Windows NT Web Server using Asp, and a 8.1.5 database located on a UNIX platform.
My question is, since I have not done anything like this, what is the simple approach needed to upload that document into the database? I would like to used a stored procedure if possible. Can I upload directly from the client having the asp feed the document into the stored procedure? Must I use a third party solution? Or is the only approach is to copy the file to the database server and use a DBMS_Lob package from a directory recognized by Oracle (via a CREATE DIRECTORY command). I am looking for simple, but any advise would be appreciated. Thank you.