This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,795 Users
  • 2,269,776 Discussions
  • 7,916,827 Comments

Discussions

inserting an image

user11153253
user11153253 Member Posts: 273
edited Apr 1, 2014 4:12AM in SQL & PL/SQL

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.

Tagged:
Moazzam

Answers

This discussion has been closed.