Re: LONG RAW and DELPHI TBLOBFIELD

Hi Mike,

This is some additional information. You should set

BLOB SIZE=10000
BLOBS TO CACHE=1000 TQuery is much faster than TTable when selecting data. But both works without errors. Our Delphi is 3.02.

Andrew Protasov

Andrew Protasov wrote in message <6l8t3v$db1_at_post.percombank.kiev.ua>...
>
>Hi Mike,
>
>What Delphi version do you use? Do you use long raw in PL/SQL
>code (stored procedures or functions)? There is limit on long raw
>variable in PL/SQL - 32K. We have no problems to select or post
>long raw as TBlobField via Ttable in Delphi 3.
>
>Andrew Protasov
>
>Mike heydon wrote in message <01bd9064$31392580$29af0bc4_at_mheydon>...
>>Has anyone managed to use Delphi with LONG RAW and TBlobFields.
>>We are trying to use this technique to store BMP files in an Oracle
>>Database.
>>The problem I have is that I can only get a max of 63K returned from the
>>LONG RAW column. The documentation states that a LONG RAW
>>column can contain data upto 2gb in size, but the maximum size returned
>>in a LONG RAW variable is 32760 bytes. How does one the access the
>>full data in a LONG RAW column ?.
>>
>>There is a setting in the BDE for BLOB SIZE which is defaulted at 32K.
>>Changing this to 1000K results in getting 63K from the LONG RAW.
>>I suspect taht this has something to do with Delphi using WORD instead
>>of INTEGER.
>>
>>It seems odd that Oracle allows a column storage of 2gb but only allows
>>a max variable retrieval of 32K. Any help would be appreciated as I appear
>>to be missing some fundamental concept.
>>
>>
>>
>>--
>>Regards,
>>Mike Heydon.
>
>
Received on Fri Jun 05 1998 - 10:12:36 CDT