Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting an image

user11153253Apr 1 2014 — edited Apr 1 2014

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2014
Added on Apr 1 2014
4 comments
379 views