Home » Developer & Programmer » Forms » Displaying image in oracle form 6i
Displaying image in oracle form 6i [message #399797] Fri, 24 April 2009 02:34 Go to next message
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
Re: Displaying image in oracle form 6i [message #399824 is a reply to message #399797] Fri, 24 April 2009 04:07 Go to previous messageGo to next message
azamkhan
Messages: 492
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
Re: Displaying image in oracle form 6i [message #399835 is a reply to message #399824] Fri, 24 April 2009 04:35 Go to previous messageGo to next message
Frank
Messages: 7877
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.
Re: Displaying image in oracle form 6i [message #399836 is a reply to message #399824] Fri, 24 April 2009 04:36 Go to previous messageGo to next message
Littlefoot
Messages: 19605
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.
Re: Displaying image in oracle form 6i [message #399851 is a reply to message #399824] Fri, 24 April 2009 04:53 Go to previous messageGo to next message
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
Re: Displaying image in oracle form 6i [message #400179 is a reply to message #399824] Sun, 26 April 2009 23:30 Go to previous messageGo to next message
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 ?
Please help me to solve the problem.

Regards,
M behera
icon11.gif  Re: Displaying image in oracle form 6i [message #400208 is a reply to message #399797] Mon, 27 April 2009 02:55 Go to previous messageGo to next message
azamkhan
Messages: 492
Registered: August 2005
Senior Member
Change you database table field from CLOB to LONG RAW

Regards,
Azam Khan
Re: Displaying image in oracle form 6i [message #400251 is a reply to message #400179] Mon, 27 April 2009 05:41 Go to previous messageGo to next message
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
Re: Displaying image in oracle form 6i [message #400283 is a reply to message #400251] Mon, 27 April 2009 07:36 Go to previous messageGo to next message
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
Re: Displaying image in oracle form 6i [message #585360 is a reply to message #400251] Fri, 24 May 2013 03:19 Go to previous message
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
Previous Topic: inserting/retriving images in oracle database 10g
Next Topic: mdi Window in form 6i
Goto Forum:
  


Current Time: Wed Sep 17 08:54:32 CDT 2014

Total time taken to generate the page: 0.11915 seconds