Home » Developer & Programmer » Forms » How to retrieve picture from the database into form through LOV
How to retrieve picture from the database into form through LOV [message #414898] Thu, 23 July 2009 23:57 Go to next message
Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan
Member
Hi,

I have two question

1) How to retrieve picture from database into form thought SELECT statement.

I am using oracle 10g form developer. I create a form which contains many fields such as Passport No. Gamca No. Sr. No. etc as shown in upload picture. Picture and other field's data save into database properly but when I want to retrieve stored data and stored picture only data is retrieve, picture is not retrieve.

I use WHEN-VALIDATE-ITEM trigger on Passport No. text item field and using SELECT statement to retrieve data from the database into form. Please help me how to use select statement to retrieve picture into form.

2) How to retrieve picture form the database into form through LOV

please help me.

  • Attachment: myp.JPG
    (Size: 45.08KB, Downloaded 600 times)
Re: How to retrieve picture from the database into form through LOV [message #414910 is a reply to message #414898] Fri, 24 July 2009 00:25 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
This question has been asked and answered often. Your previous thread included.

Search this forum for 'blob image'.

David
Re: How to retrieve picture from the database into form through LOV [message #414928 is a reply to message #414898] Fri, 24 July 2009 01:30 Go to previous messageGo to next message
Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan
Member
can you please post the related search topics of my problem. I tried but failed to find the solution of my problem.

advance thanks
Re: How to retrieve picture from the database into form through LOV [message #414953 is a reply to message #414898] Fri, 24 July 2009 02:24 Go to previous messageGo to next message
blaxmi
Messages: 36
Registered: May 2008
Location: Hyderabad
Member
Hi,

Can i please know the datatype of the variable that you have used for picture data.
Re: How to retrieve picture from the database into form through LOV [message #414959 is a reply to message #414898] Fri, 24 July 2009 02:45 Go to previous messageGo to next message
Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan
Member
i create a table for storing pictures

Table Name :Images

Column Name : Datatype
-----------------------------
ID : varchar2(20)
images : blob

[Updated on: Fri, 24 July 2009 02:46]

Report message to a moderator

Re: How to retrieve picture from the database into form through LOV [message #415266 is a reply to message #414959] Sun, 26 July 2009 23:58 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Look at http://www.orafaq.com/forum/m/414064/67467/?srch=blob+image#msg_414064 and the thread to which it points.

David
Previous Topic: FRM-92101
Next Topic: Upgrade Form6i to Form9i
Goto Forum:
  


Current Time: Fri Sep 20 09:34:05 CDT 2024