BLOB or BFILE?

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Thu, 3 Jun 2004 12:03:40 -0500
Message-ID: <C398496DF88AD711908C00065BEEE32CFE99D1@dfwmail.quovadx.com>

List,

I need your opinion on the case which I am working on?

I have a application which connect to Oracle database(9.2.0.5) via ODBC connection , thru this connection application send a File(between 5 to 40 M) average 20 times a night then these file will be later downloaded from the user thru the application I have two Options as follows:

Store the file as BLOB into the table using store procedure to write the BLOB to the table BUT I don't know how do I have to send it back to the application via ODBC?
Using BFILE and store the FILE in Database server in this case do I have to COPY the file into the directory which I have define in oracle if yes How do I have to COPY the file into the directory via ODBC?

Finally which of these two way will be more efficient?

Thanks for your help appreciate.

Hamid Alavi

Office : 818-737-0526
Cell phone : 818-416-5095

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Jun 03 2004 - 11:52:09 CDT