Home » Developer & Programmer » Forms » Displaying database stored image on Oracle Forms 6i (Oracle 10g Database, Forms 6i)
icon1.gif  Displaying database stored image on Oracle Forms 6i [message #478065] Wed, 06 October 2010 01:07 Go to next message
aupurbo
Messages: 6
Registered: October 2010
Location: Dhaka
Junior Member

Hi There!
I have successfully Stored image file in Oracle 10g Database Table using Forms 6i. But I cannot retrieve that image and display on Forms 6i. Image Item on Form is not a database Item. Please help me out...

[MERGED by LF]

[Updated on: Wed, 13 October 2010 00:54] by Moderator

Report message to a moderator

Re: Displaying Database stored image on oracle forms 6i [message #478073 is a reply to message #478065] Wed, 06 October 2010 01:43 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
- images are in the database
- there's an image item on the form
- image item is not a database item
- why not?

Anyway: I guess your case and this one require the same reading.
Re: Displaying Database stored image on oracle forms 6i [message #478076 is a reply to message #478073] Wed, 06 October 2010 01:54 Go to previous messageGo to next message
aupurbo
Messages: 6
Registered: October 2010
Location: Dhaka
Junior Member

I need the coding for retrieving image file from database and to display on the image item on forms 6i
Re: Displaying Database stored image on oracle forms 6i [message #478081 is a reply to message #478076] Wed, 06 October 2010 02:05 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so search the board; it's been discussed previously, so I'm quite sure you'll find either code or guidelines. Just search (or would you want me to do it for you?).
Re: Displaying Database stored image on oracle forms 6i [message #478083 is a reply to message #478081] Wed, 06 October 2010 02:07 Go to previous messageGo to next message
aupurbo
Messages: 6
Registered: October 2010
Location: Dhaka
Junior Member

Thanks Moderator... if you could, please do it for me, I am a new user. or show me the thread. thanks..
Re: Displaying Database stored image on oracle forms 6i [message #478092 is a reply to message #478083] Wed, 06 October 2010 03:29 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is OraFAQ Forum's Search facility. It is simple to use it, so ... take yout time, see what's been offered.

Another option is to use Google and include the "site" hint; in Google's "Search" field, you'd put
site:www.orafaq.com/forum form display image
(like this: Let me Google that for you).

Another useful site is Oracle Technology Network. You'll find all kinds of downloads, documentation etc., as well as forums. Forms is what you'll probably want to see.

Good luck!
Retrieve BLOB image from database using forms 6i [message #478853 is a reply to message #478065] Tue, 12 October 2010 23:51 Go to previous messageGo to next message
aupurbo
Messages: 6
Registered: October 2010
Location: Dhaka
Junior Member

I have successfully inserted image file in BLOB column in Oracle 10 Database using forms 6i. But I do not know how to retrieve BLOB columns using forms 6i and pl/sql code. Forms items are not database item. I do not want to use execute_query which could be solution. please anybody help me out.
icon7.gif  Re: Retrieve BLOB image from database using forms 6i [message #498727 is a reply to message #478853] Thu, 10 March 2011 22:04 Go to previous messageGo to next message
devendrapal26
Messages: 15
Registered: March 2011
Location: india
Junior Member

how can u insert a blob file using form6i, wiil u please give me a code for that....
Re: Retrieve BLOB image from database using forms 6i [message #519279 is a reply to message #498727] Wed, 10 August 2011 12:43 Go to previous message
markmelo
Messages: 1
Registered: August 2011
Junior Member

Code for insert blob file using Forms

FORMS_OLE.ACTIVATE_SERVER('table_name.column_name');
FORMS_OLE.INITIALIZE_CONTAINER('table_name.column_name', file_name);
FORMS_OLE.CLOSE_SERVER('table_name.column_name');

However this code doesnt work after upgrading Adobe Reader to version 10.0.0



Previous Topic: Deleting records from block
Next Topic: How to call a batch file existing in network path through oracle forms 6i
Goto Forum:
  


Current Time: Sun Sep 08 23:05:20 CDT 2024