Re: BLOB fields and Delphi 5

Hi,

We are using Blobs to store images. I can' t tell you anything about Delphi, but in Powerbuilder, the regular Insert didn't work, we have to insert a special NullBlob, then use UpdateBlob rather than a regular Update to insert the image. Possibly Delphi has some special Blob functions like this as well.

At 02:05 PM 10/13/00 -0800, you wrote:

> Hi,
>
> I'm trying to load a binary file into a blob field using delphi 5.
> I tried to define a different BlobTypes as : Memo, Blob, Cblob ...
>at the delphi side.
> Unfortunatly, I've got an error telling me that the datatypes (at
>both sides -> DB and Delphi)
> are incorrect. Apparently, the insert sql process is trying to
>convert datatypes but got a problem during the insertion (wrong datatypes
>Hex and Binary).
>
> Does anyone knows how can I fix that problem? or Which type of field
>in Oracle, should I use for images (blob, long raw, raw(x) ...)?
>
> Thanks in advance,
> Jordi
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jordi Sanmarti
> INET: JSanmarti_at_tss.com.pe
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Fri Oct 13 2000 - 18:17:04 CDT