Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Anybody?
IN DBMS_LOG.WRITE,
amount is the # if bytes to write. You should control this to a smaller
value than 32767 dynamically. In your code I couldn't find where you
fill out BUFFER. That's where you should also control the value of
AMOUNT.
DBMS_LOB.WRITE (
lob_loc IN OUT NOCOPY BLOB,
amount IN BINARY_INTEGER, offset IN INTEGER, buffer IN RAW);
DBMS_LOB.WRITE (
lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
amount IN BINARY_INTEGER, offset IN INTEGER, buffer IN VARCHAR2 CHARACTER SET lob_loc%CHARSET);
lob_loc
Locator for the internal LOB to be written to. For more information, see Operational Notes.
amount
Number of bytes (for BLOBs) or characters (for CLOBs) to write, or number that were written.
offset
Offset in bytes (for BLOBs) or characters (for CLOBs) from the start of the LOB (origin: 1) for the write operation.
buffer
Input buffer for the write.
On Jun 7, 2004, at 1:51 PM, Hamid Alavi wrote:
> 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
>> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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 -----------------------------------------------------------------Received on Mon Jun 07 2004 - 15:49:55 CDT
![]() |
![]() |