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.

--------------------------------------------------


We're not experts on Delphi but a quick search through the Oracle documentation came up with these reference manuals that should help.


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.

For more help with PL/SQL see our Oracle PL/SQL tutorial.

If you're interested in formal Oracle training (either on-line or in a classroom) then see our Oracle training page for more information.

Comments for Accessing blobs from an Oracle database in a Delphi 7 program

Average Rating starstarstarstarstar

Click here to add your own comments

May 17, 2011
Rating
starstarstarstarstar
BLOB issue
by: Anonymous

You need to enter the location of the pic in the drive in the Blob coloumn.

if pic is saved in c drive then
('c:\pic.bmp')

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.