Home » Developer & Programmer » Forms » inserting/retriving images in oracle database 10g
inserting/retriving images in oracle database 10g [message #447242] Fri, 12 March 2010 11:23 Go to next message
kalpataru
Messages: 69
Registered: January 2010
Location: INDIA
Member
hello sir,
how can i insert a image by selecting an image
from any drives of my system to oracle database
and retriving that image for displaying purpose
after inserting that image.

if possible give me a sample form.


like vb 6.0 or vb.net in textbox's change trigger fires...
instantly when we start typeing in the text boxes...

can you give me the sample form of doing this by
by using java beans.





CM: Changed topic title to something vaguely descriptive. Please don't name topics after yourself.


MERGED by LF

[Updated on: Sun, 14 March 2010 12:06] by Moderator

Report message to a moderator

Re: Images and list items [message #447284 is a reply to message #447242] Fri, 12 March 2010 22:43 Go to previous messageGo to next message
tamzidulamin
Messages: 131
Registered: October 2009
Location: Dhaka
Senior Member
Dear,

Please follow the steps below:

01. Create a table with a column with BLOB data type(also you can take your necessary column).
02. Develop a form with the above table by using wizard.
03. Now create a control block with a browse button and
write a WHEN-BUTTON-PRESSED trigger by using READ_IMAGE_FILE(read your image into your IMAGE_ITEM) & GET_FILE_NAME(getting your image file path & file name) builtin to get your desire image into your IMAGE Item.
04. Now Commit your form & again query to see your image from database.
05. Do It Now!!!

Regards
Tamzidul Amin.
inserting/retriving images in oracle database 10g [message #447373 is a reply to message #447242] Sun, 14 March 2010 05:42 Go to previous messageGo to next message
kalpataru
Messages: 69
Registered: January 2010
Location: INDIA
Member
dear tamzidulamin sir,
what you have told me it very finely working in block level.

but i want write the insert statements

i am creating a table with id number,images blob
datatypes.

statement for insrting an image
my block name is :block_image
and my image item name is image_name

when i am writing
INSERT INTO SCOTT.IMAGES(ID,IMAGES) VALUES(1,:block_image.image_name);

it it showing error that bad bind variable name :block_image.image_name

same type of error for retriving also
in select statement.
when i am writing
select images into :block_image.image_name from scott.images;

please tell me how to do this way.
Re: inserting/retriving images in oracle database 10g [message #447382 is a reply to message #447242] Sun, 14 March 2010 17:06 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
1) Why are you hard-coding this? The whole point of forms is that you don't have to.
2) Do you really think having a column with the same name as the table it belongs to is a good idea?
3) What triggers are you writting this code in?
Re: inserting/retriving images in oracle database 10g [message #447502 is a reply to message #447382] Mon, 15 March 2010 09:06 Go to previous messageGo to next message
kalpataru
Messages: 69
Registered: January 2010
Location: INDIA
Member
thanks for your respnose

my aim is that i want all the things like insert an image and selecting an image through statements not through block level.

if the name is same(a column with the same name as the table it belongs) then tell me how to do this.

i am writting this code is when button pressed;

i want all the controls in my hand not in block level.

if i change the name also then it is showing the same error.

please sir replay me.
Re: Images and list items [message #482132 is a reply to message #447284] Tue, 09 November 2010 23:49 Go to previous messageGo to next message
wazir
Messages: 18
Registered: February 2010
Junior Member
Can any body guide me how to retrieve image from db.. I am posting this question after searching all the forum and there are so many post available regarding images but for retrieving no clear help is there... i wants to view images with external viewer like irfan or any other..

i am using form 6i and oracle 10g..
Re: inserting/retriving images in oracle database 10g [message #585358 is a reply to message #447242] Fri, 24 May 2013 03:17 Go to previous message
beimage
Messages: 6
Registered: May 2013
Junior Member
i was having the same problem, any help would be appreciated by us.
Previous Topic: how to check the syntax of the resulting insert in oracle forms 6i
Next Topic: Displaying image in oracle form 6i
Goto Forum:
  


Current Time: Thu Apr 17 03:47:16 CDT 2014

Total time taken to generate the page: 0.05489 seconds