OraFAQ Forum: Forms » Displaying image in oracle form 6i

Home » Developer & Programmer » Forms » Displaying image in oracle form 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Displaying image in oracle form 6i [message #399797]

Fri, 24 April 2009 02:34

ht_maya
Messages: 16
Registered: April 2009
Location: ORISSA, INDIA

Junior Member

Hi,
First time, i am working with image. I have successfully stored image in oracle table. Now i want to display the stored image in oracle form 6i. There i unable to display the image although i have created the data block using the same table name as the data source. Can anybody please help in this matter?

Thanx & best regards,

M behera

Report message to a moderator

Re: Displaying image in oracle form 6i [message #399824 is a reply to message #399797]

Fri, 24 April 2009 04:07

azamkhan
Messages: 557
Registered: August 2005

Senior Member

I am also working with DB stored images and successfully retriving images from database.

I should work by creating a base table block of the corespondent database image table and issue execute query on it and you will get the images in the image item.

Regards,
Azam Khan

Report message to a moderator

Re: Displaying image in oracle form 6i [message #399835 is a reply to message #399824]

Fri, 24 April 2009 04:35

Frank
Messages: 7901
Registered: March 2000

Senior Member

And since you consider yourself more important then others, you decided to report your post to get more attention?
Bad idea. In fact, 99% of the time this works contra-productive.

Report message to a moderator

Re: Displaying image in oracle form 6i [message #399836 is a reply to message #399824]

Fri, 24 April 2009 04:36

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Reported by ht_maya

I have created a data block using the table my_docs having columns id number, name varchar2 doc blob. During runtime, i am executing the form. Data are coming for id & name field. But doc (i.e image item) is coming as blank. Please suggest what should i do ? Regards, M behera

ht_maya, please, do not "Report message to a moderator" as it is visible only to ... well, moderators. Other Forum members do not see these messages. If you want to continue discussion, just "Reply" to the previous post.

Report message to a moderator

Re: Displaying image in oracle form 6i [message #399851 is a reply to message #399824]

Fri, 24 April 2009 04:53

ht_maya
Messages: 16
Registered: April 2009
Location: ORISSA, INDIA

Junior Member

I have created a data block using the table my_docs having columns
id number,
name varchar2
doc blob.

During runtime, i am executing the form(execute_query). Data are coming for id & name field. But doc field(i.e image item) is coming as blank. Please suggest what should i do ?

Regards, M behera

Report message to a moderator

Re: Displaying image in oracle form 6i [message #400179 is a reply to message #399824]

Sun, 26 April 2009 23:30

ht_maya
Messages: 16
Registered: April 2009
Location: ORISSA, INDIA

Junior Member

Report message to a moderator

Re: Displaying image in oracle form 6i [message #400208 is a reply to message #399797]

Mon, 27 April 2009 02:55

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Change you database table field from CLOB to LONG RAW

Regards,
Azam Khan

Report message to a moderator

Re: Displaying image in oracle form 6i [message #400251 is a reply to message #400179]

Mon, 27 April 2009 05:41

danish_fsd@yahoo.com
Messages: 38
Registered: February 2008
Location: Pakistan

Member

Hi,

I think the problem is in your image insertion, not in retrieval. Try following query.

SELECT id, name,
      dbms_lob.getlength(doc) "Photo Size"
FROM my_docs;

If 'Photo Size' column gives zero ('0') then it means image is not inserted in database.

Regards.

Danish

Report message to a moderator

Re: Displaying image in oracle form 6i [message #400283 is a reply to message #400251]

Mon, 27 April 2009 07:36

ht_maya
Messages: 16
Registered: April 2009
Location: ORISSA, INDIA

Junior Member

I run the query in sql. But size is not 0.
Please see the sql editor.
(I have attached the script by which i inserted image in oracle table.
Please check it.)

SQL> ed
Wrote file afiedt.buf

1 SELECT id, substr(name,1,20),
2 dbms_lob.getlength(doc) "Photo Size"
3* FROM my_docs
SQL> /

ID SUBSTR(NAME,1,20) Photo Size
--------- -------------------- ----------
1 APPL_FORM.PDF 80836
2 CIMG1860.JPG 1191991

Attachment: STORING_IMAGE_IN_ORACLE.txt
(Size: 2.69KB, Downloaded 2962 times)

Report message to a moderator

Re: Displaying image in oracle form 6i [message #585360 is a reply to message #400251]

Fri, 24 May 2013 03:19

beimage
Messages: 6
Registered: May 2013

Junior Member

thank you for your tip. very great image codes. i will use it. hope it will work

Report message to a moderator

Previous Topic:	inserting/retriving images in oracle database 10g
Next Topic:	mdi Window in form 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:52:28 CDT 2024