Storing images in oracle 8i

Images can be stored in an oracle database using the datatype long raw or blob. Since you are using oracle8i it is better that you use blob. To manipulate data through forms you can make use of the image item or ole item in forms. You'll have to create a block based on the table and specify the particular item as an ole item.

cheers
crsankar

Crsankar

Thanx for replying .
Can you pls tell me in detail how to insert images in
blob data types , as i am receiving error.
waiting for reply .

Please specify the error message that you are receiving and the method that you are using to insert the image.

Crsankar

i created table :

create  table image (image blob) ;
and
insert into image values ('d:\eat') ;
/
ORA-01465: invalid hex number
as images are on 'd:' drive image name is eat.

Pls reply

crsankar

Thanx for replying.
where i can find DBMS_LOB package and how to utilize it by inserting images?
please guide me.

You can find info on dbms_lob package in the oracle documentation set, specifically the Oracle 8i server and datawarehousing one -> Oracle8i Supplied PL/SQL Packages Reference.

Please update and finalize this old, open question.  Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,
Moondancer - EE Moderator

Force-accepted.

Netminder
CS Moderator