Insert Image into Oracle BLOB, passin image as blob prameter

Manfredt · Post by **Manfredt** » Tue 21 Jul 2009 19:28

How can i insert an image into Oracle BLOB field using TOraStoredProc
and TOraQuery Delphi components.
I have tried but failed. I have developed a scanning application
using the Pegasus ActiveX components. The
scanned images are temporarily stored in MYSQL in a field defined
as a BLOB and then moved to Oracle in a table having a BLOB field.
Storing the images in MYSQL is not a problem. I have a big problem
storing the images in a BLOB field in Oracle, and I urgently need help
regarding the following issues (I am using the Devart Data
Access Components in Direct mode with Delphi 2009):

1. Reading a pdf file into TOraStoredProc (or TOraQuery) and saving
this image file in a BLOB field in Oracle;

2. Show me a sample Oracle stored procedure receiving the blob as
a parameter and storing the BLOB in a table having a BLOB field;

3. Instead of reading the image from a local file receive the image from
MYSQL BLOB field and store this image in an Oracle Blob filed.

4. Are there issues with Oracle passing BLOBs as parameter where the
BLOB is say 2 MB?

Please help it is urgent and I am desperate.

Manfredt Kavetu
[email protected]

Challenger · Post by **Challenger** » Thu 23 Jul 2009 06:55

Please take a look at the "Working with BLOB and CLOB Data Types" article in the ODAC help. You can also try our General Demo. As to your last question, there is no such restrictions when working with blobs in Oracle.