Re: Grafix?

Here is some PL/SQL code that I have yet to get working.... Quick answer... use the DBMS_LOB package....

DECLARE
filevar BFILE;
blobvar BLOB;
result INTEGER;
amount INTEGER;
filename CHAR(20);
dir_alias CHAR(100);

BEGIN
--first create a Oracle directory
--using create directory FILEDIRGEOGA as '/oracle/oracle8owner/data';

filevar := BFILENAME('FILEDIRGEO','logo2.gif');

• does the file exist ? result := DBMS_LOB.FILEEXISTS(filevar); IF (result != 1) THEN DBMS_OUTPUT.PUT_LINE('***Error occured while opening data file !***'); ELSE DBMS_OUTPUT.PUT_LINE('*** Data file opened successfull !***'); END IF;
• open the file and initialize the locators insert into blobtable(name,b) values('EMPTYLOB',EMPTY_BLOB()); DBMS_LOB.FILEOPEN(filevar); DBMS_LOB.FILEGETNAME(filevar,dir_alias,filename); amount := DBMS_LOB.GETLENGTH(filevar); BEGIN SELECT blobtable.b into blobvar FROM blobtable WHERE blobtable.name='EMPTYLOB'; DBMS_LOB.LOADFROMFILE(blobvar,filevar,amount); END;
• insert into the blobtable UPDATE blobtable SET name=filename,b=blobvar; DBMS_LOB.FILECLOSE(filevar);

COMMIT;
END;
/

You can use forms too. Create an image_item and call. read_image_item('path to the bmp file','BMP','block_name.image_item_name'); Make sure the block is set up to query a base_table you want to store your image in.
Then hit F10 to commit it to a blob or long raw column. Note: The valid image file types are: BMP, CALS, GIF, JFIF, PICT, CALS, RAS, TIFF, or TPIC. (Note: File type is optional, as Forms 5 will attempt to deduce it from the source image file. To optimize performance, however, you should specify the file type.)

ecatz wrote:

> Hi!
>
> Can anyone tell me how I can read a bmp file from the local drive and store
> it in an Oracle table in PL/SQL?
>
> Thanks
>
> ECatz

--
Tim McConechy
Database Administrator/Programmer Analyst
WestCoast Interchange Enterprises
Phone:(250) 472-4331
Fax:(250) 721-6497
Email: tmcconec_at_wie.com
http://www.wie.com