Board index » delphi » inserting jpeg images into Oracle8 BLOB field

Martina Petrovicova

Delphi Developer
Mon, 03 May 2004 05:11:46 GMT

inserting jpeg images into Oracle8 BLOB field

I have a problem:

when I'm trying to insert the jpeg images (C++ Builder 5) using BDE  into
Oracle8 field which type is BLOB, the image is not inserted correctly - only
the first 32KB of the image are correct then is 1 byte inserted 2-times and
the image is of course bad.

Can I insert images larger than 32KB - how?

Thanks
Martina.

 
John Pierc

Delphi Developer
Tue, 04 May 2004 00:58:08 GMT

Re:inserting jpeg images into Oracle8 BLOB field


I assume you're using SqlLinks.

1.  Set the BlobSize parameter in the BDE;  warning:  max is 1000000; or

2.  Set RequestLive and do the insert (no max).

John Pierce

Other Threads

1. Problems inserting a JPEG file to a Blob field

2. Storing a JPEG image in a paradox BLOB field

3. JPEG images in database and clearing BLOB field

4. saving jpeg image into an Interbase 6 blob field

5. Getting JPEG images from a BLOB field

6. Problem inserting blob field into another blob field using two ibsql

7. Insert the Image to the BLOB field!!!!!

8. JPEG error #51 - Trying to store a JPEG in a Interbase BLOB field

9. JPEG Error loading a JPEG Image from BlobBinary field

10. Enter Data into BLOB-Fields with Oracle8 / SQL 7