OraFAQ Forum: Forms » Display image on oracle form thru backend..

Home » Developer & Programmer » Forms » Display image on oracle form thru backend.. (oracle 10g, form 10g...)

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

Display image on oracle form thru backend.. [message #535902]

Sat, 17 December 2011 04:58

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi friend,

I am successfully insert image in DB now...now my task is i want to retrieve this image on my oracle form....friends help me how to achieve it..

my structure on table like this..

CREATE TABLE temp_image
 (
 ID NUMBER,
 image_filename VARCHAR2(50),
 image BLOB
 );

i inserted 2 images on that... now i want to retrieve it , how to achieve this...

Report message to a moderator

Re: Display image on oracle form thru backend.. [message #535909 is a reply to message #535902]

Sat, 17 December 2011 06:26

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi friend,

I create data block of that table ...but my problem is now...in table i insert 3 record...but while i execute this data block ..only one image shown ...2 image doesnt shown...i dont what happens ??

Report message to a moderator

Re: Display image on oracle form thru backend.. [message #535959 is a reply to message #535902]

Sun, 18 December 2011 04:21

amit290288
Messages: 2
Registered: December 2011
Location: INDIA

Junior Member

Hi Swapnil,

I'm very new to oracle & m using forms 6i.. Can u please tell me how to use image & how to store image in database.. If possible can u please send me any sample forms & relevant codings so that it'll be helpful.

Thanks in Advance.
Amit

Report message to a moderator

Re: Display image on oracle form thru backend.. [message #535978 is a reply to message #535959]

Sun, 18 December 2011 13:20

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

Senior Member
Account Moderator

Learn how to use Search facility.

For example, this topic contains a sample form attached by one of our members.

Report message to a moderator

Re: Display image on oracle form thru backend.. [message #536003 is a reply to message #535959]

Sun, 18 December 2011 22:04

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi amit,

Just check this script...and do it same.

On Form level I am still facing some problem, once i resolved it i will tell u...

Attachment: image_insert_on_db.sql
(Size: 1.41KB, Downloaded 1747 times)

Report message to a moderator

Re: Display image on oracle form thru backend.. [message #536017 is a reply to message #536003]

Mon, 19 December 2011 00:05

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Friends,

I solved my issue....but i still confused...i tell you why.
My database type for IMAGE column is BLOB.
AS Per oracle documentation, The size of BLOB, CLOB, and NCLOB data can be up to (4 gigabytes -1)
By using database block based on that table i create field. So imge field get automatically image data type..
I want to know what is max. size of that data type.
Because while showing pics on form, pics size which is greater than 1000kb doesnt not display. so help
me out .

Report message to a moderator

Re: Display image on oracle form thru backend.. [message #536102 is a reply to message #536017]

Mon, 19 December 2011 03:57

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

I'd ask oracle that one.

Report message to a moderator

Previous Topic:	How to hide/suppress user defined alert messages
Next Topic:	Forms in new tab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 26 00:41:06 CDT 2024