Accessing blobs from an Oracle database in a Delphi 7 program

by Aliyev M
(Baku)

Hi, I create table in oracle 10g xe as:
create table empblob(
empno int,
name varchar2(30),
pic blob);

How can I insert and manage blob files this table with delphi7? I am working with ADO components.


Unfortunately we're not experts with Delphi but a quick hunt through the Oracle documentation came up with these reference manuals that should help.

• 
  Oracle Provider for OLE DB Developer's Guide
  11g Release 2 (11.2) for Microsoft Windows
• Oracle Database SecureFiles and Large Objects Developer's Guide
  11g Release 2 (11.2)

You would probably find it easier though to use PL/SQL to manipulate your BLOB. DBMS_LOB (see Oracle Database PL/SQL Packages and Types Reference) contains various procedures and functions for accessing and manipulating LOBs.