hiiiiiiiii friends shall i insert pic into database
by using BLOB DATATYPE.
when ever i am trying to insert a pic by using BLOB I GET
a error (ORA-01465: invalid hex number),
so help me?
keesara
Printable View
hiiiiiiiii friends shall i insert pic into database
by using BLOB DATATYPE.
when ever i am trying to insert a pic by using BLOB I GET
a error (ORA-01465: invalid hex number),
so help me?
keesara
You cannot insert a pic directly into BLOB Column.
You have to use a package called dbms_lob or some third party software which converts the pic file into binary and inserts into database.
There are various methods and examples given for JDBC, VB (OO4O) and C given in Oracle documentation.
Just to give you an idea, you can see my post in:
http://www.dbasupport.com/forums/sho...threadid=17608
[Edited by Raminder on 11-08-2001 at 06:33 AM]