Home » Developer & Programmer » Forms » Pciture can save & reterive in Oracle
Pciture can save & reterive in Oracle [message #161803] Tue, 07 March 2006 05:09 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
hi

I am using Oracle 8.0.6 & 6i I want to save and reterive pictures in table please tell me how can I make this possible.

I am biggner.
Re: Pciture can save & reterive in Oracle [message #161902 is a reply to message #161803] Tue, 07 March 2006 16:54 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Displaying Images
"Displaying Image in Forms 6i from BLOB Database field" http://www.orafaq.com/forum/t/51889/67467/

"Displaying Image in Report 6i from named file" http://www.orafaq.com/forum/m/157010/67467/#msg_157010

About loading and displaying images files cs-netlab-01.lynchburg.edu/ courses/Oracle/PPTSlides/08ch.ppt

David
3 or 4 Images can save in table [message #161949 is a reply to message #161803] Wed, 08 March 2006 00:17 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
***********Thank you Orafaq.com Forum********

I create table image_table.

Name Null? Type
------------------------------- -------- ----
FILENAME NOT NULL VARCHAR2(255)
IMAGE LONG RAW

**write a triger

--when-validate-item-- on filename

DECLARE
filename VARCHAR2(256);
BEGIN
filename := GET_FILE_NAME(File_Filter=> 'JPEG Files (*.jpg)|*.jpg|');
READ_IMAGE_FILE(filename, 'JPG', 'image_table.image');
end;

I am working on this and working well but it stores one image in one table.

Now I want to store 3 or 4 image in table.

this is possbile???

Kamran
Re: 3 or 4 Images can save in table [message #162143 is a reply to message #161949] Wed, 08 March 2006 23:32 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Display four rows, put data into each row and then save.

David
Previous Topic: Alert and Timer expired
Next Topic: GAL access through developer 2000 form
Goto Forum:
  


Current Time: Fri Sep 20 05:01:23 CDT 2024