Home » Developer & Programmer » JDeveloper, Java & XML » insert command (java 6 and oracle 11g)
insert command [message #449519] Tue, 30 March 2010 04:43 Go to next message
aarthimanikandan
Messages: 4
Registered: March 2010
Junior Member
sir i want to insert image data into table by using java command "INSERT INTO imgapp values ( 1, "Dr.xxx" , "G:/rrrr ultra sound images/12 Week Ultrasound Picture/02us12b.jpeg")"; this gives a error how we can insert the image to oracle 11g or it can be done straight away in the oracle by the command insert into imgapp values(1,"Dr.xxxxx",""G:/rrrr ultra sound images/12 Week Ultrasound Picture/02us12b.jpeg")"; please help me to over come this problem sir. Smile

[MERGED by LF]

[Updated on: Mon, 05 April 2010 11:54] by Moderator

Report message to a moderator

Re: insert command [message #449527 is a reply to message #449519] Tue, 30 March 2010 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=oracle+insert+image&aq=f&aqi=g1&aql=&oq=&gs_rfai=
Razz

Regards
Michel
insert error [message #450167 is a reply to message #449519] Mon, 05 April 2010 08:42 Go to previous messageGo to next message
aarthimanikandan
Messages: 4
Registered: March 2010
Junior Member
as you have said the insert command but its not working for me sir please can you say a model code fragment for inserting a image in the oracle from the directory like G:\img folder\ultra sound image\02us12a.jpeg please help me sir Sad
Re: insert error [message #450169 is a reply to message #450167] Mon, 05 April 2010 09:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And this is related to what?
Continue in the same topic without the previous parts your post is meaningless.

Regards
Michel
Previous Topic: Retrieving Custom Oracle Types ala Java JDBC
Next Topic: Need help returning int from Java SP to PL/SQL SP
Goto Forum:
  


Current Time: Thu Mar 28 18:40:28 CDT 2024