storing graphics in database

[satishpc]

hi ,

i use crystal reports( a seagate product) and i have a logo of my company using this product is displayed in the report. but the problem is that this logo changes frequently as we have diff companies using it. can i store the image in a table and put it dynamically in the crystal reports report ? has anyone done something like this before ? thanks .

satishpc

[parthiban]

hi ,
step 1:
Create a dir using the following command and give the directory name where your logo is stored.

Example : Asssuming that your logo is stored in /tmp/logo.bmp

CREATE DIRECTORY LOGO_DIR AS '/tmp';

step 2:
Create a table with column of BFILE type

example :
Create table Logo_tab ( logo_id number, logo BFILE):

step 3:
use insert comand to load image into table. Give the logo file name ( may be .bmp or .gif etc)

insert into map_tab
values ( 1, BFILENAME('LOGO_DIR','logo.bmp') );
----

If you have any question reply back!