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@xxxxxxx]
Sent: Monday, June 07, 2004 1:34 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
> 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
> -----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: