RE: Anybody?
- From: Hamid Alavi <hamid.alavi@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Jun 2004 15:51:02 -0500
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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
