| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Anybody?
My question is: the file size between 5 to 40 Meg is there any way to check
the size of the file which passing thru the application then end the storing
blob or not?
right now I have defined buffer = 32767 may be this is too big is there any
way to define this smaller and check the actual file size then insert
another chunk till end or not?
Thanks,
-----Original Message-----
From: Fernando [mailto:fernandoluis_at_mac.com]
Sent: Monday, June 07, 2004 1:34 PM
To: oracle-l_at_freelists.org
Subject: Re: Anybody?
Hamid, It's kind of a "not usual" experience to send 40Mb files through ODBC. You have much less overhead if you just use FTP or other method that doesn't have a SQLNet overhead.
But what do you mean by "controlling" the buffer, amount & position? These vars are used to process these large files by chunks, so, if you could read a chunk from the OS, network, etc, and add it to the BLOB that way. If you mean to call several times the procedure (? don't know if I understood your question), then you should probably return these values also.
I am not sure about Position starting at 1. Normally is zero, isn't it? But I have only used these chunk functions in C.
On Jun 7, 2004, at 1:11 PM, Hamid Alavi wrote:
> This morning I send an email regarding BLOB just wonder if anybody
> received
> it or if anybody have any Idea??
>
> Thanks all
>
> 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
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Mon Jun 07 2004 - 15:42:11 CDT
 |
 |