| inserting/retriving images in oracle database 10g [message #447242] |
Fri, 12 March 2010 11:23  |
kalpataru
Messages: 72
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  |
tamzidulamin
Messages: 132
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 |
kalpataru
Messages: 72
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 #447502 is a reply to message #447382] |
Mon, 15 March 2010 09:06 |
kalpataru
Messages: 72
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 |
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..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
