Discussions
Categories
- 385.5K All Categories
- 4.9K Data
- 2.5K Big Data Appliance
- 2.4K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
inserting an image

Hi folks,
how can i insert a image which is GIF or JPG format into a oracle database table
for example i have tabe imagetesttable and image is TEST1.GIF
>desc ebase.imagetesttable
Name Null Type
----- ---- ----
IMAGE BLOB
>insert into ebase.imagetesttable values('C:\Users\mohammh1\Desktop\TEST1.GIF');
it throwing an error.
Error report:
SQL Error: ORA-01465: invalid hex number
01465. 00000 - "invalid hex number"
*Cause:
*Action:
can any body suggest me.
Answers
-
There is no auto conversion for blobs in sqlpus.
3 secons in Google lea to this with some more effort you may find a document for your actual database release but that may containg the verry same information...
bye
TPD
-
you need to dbms_lob.loadfromfile to convert file to binary and put them in BLOB
check following link.
-
1) First create directory object e.g.
CREATE DIRECTORY imgdir AS 'C:\images\';
2) Write procedure to insert data e.g. sample procedure:
CREATE OR REPLACE PROCEDURE load_file ( pfname VARCHAR2) IS l_size number; l_file_ptr bfile; l_blob blob; BEGIN l_file_ptr := bfilename('IMGDIR', pfname); dbms_lob.fileopen(l_file_ptr); l_size := dbms_lob.getlength(l_file_ptr); INSERT INTO images ( img_id, icon ) VALUES ( image_id.NEXTVAL, empty_blob() ) RETURNING icon INTO l_blob; dbms_lob.loadfromfile(l_blob, l_file_ptr, l_size); COMMIT; dbms_lob.close(l_file_ptr); END;
3) Now execute the procedure passing it the file name. e.g.
EXECUTE LOAD_FILE('img1.jpg');
Please read How to create the table in Oracle that is populated by images(blob fields) | Jaspersoft Community for details.
-
Hi Mozzam,
i have don this by below
insert into ebase.image_table values('\\HQIT2-EVEREST\G:\image\test2.JPG');
1 row inserted
commit;
thanks