-
Hi, I am trying to find out the method for storing images in Oracle database but I can't seem to find any documentations on it.
I have tried Metalink but to no avail - if anyone can give me any help of info, please let me know!
-
Use BLOB column for the image and store them externally to the database.
-
Search for dbms_lob package , and also OCI with dbms_lob.
-
Hi,
You should use BLOB or BFILE datatype.
If you need in a tool for loading imagies contact me at support@ispirer.com
Best regards, Dmitry
--
[url]http://www.ispirer.com[/url] - Database migration tools and services for Oracle and IBM DB2.
-
seeing is beleiving or is it pic is worth a 1000 words
there are more than one way to store lob data
a) you can use dbms_lob package
b) you can use oci ( thsi is the fasyest way to load data)
c) or you could use the good ol sql loadeer yeah you bet baby you can do it with sql loader heres an example of how i did it with my databse on linux 6.2 running oracle 8.1.6 r2 at my home. interested to know read on
Using SQL*Loader to Load Rich Data
SQL*Loader can load whole files into internal LOBs. For example, let's add one column called MY_RESUME to the recipes table.
ALTER TABLE RESUMES
ADD (MY_RESUME BLOB DEFAULT EMPTY_BLOB());
The MY_RESUME column will hold Adobe Acrobat PDF files that contain the most recent update of my resume. You can bulk load existing resumes into the database with SQL*Loader. In this example, a file named resumess.dat, containing data targeted for insertion into the RESUMES table.
1,HRISHI' s resume
,/u12/oracle/admin/dev/dishimages/1.pdf,
2,Fiona ,/u12/oracle/admin/dev/dishimages/2.pdf,
When loading the data, you use a SQL*Loader control file similar to this example:
LOAD DATA
INFILE 'resumes.dat'
APPEND INTO TABLE RESUMES
FIELDS TERMINATED BY ','
(name, external_filename FILLER,
resumes LOBFILE(external_filename)
TERMINATED BY EOF
)
enjoy
:-)
-
Thank you all for your reply and help! Much appreciated! >o<
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|